Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I want to convert decimal values into hh:mm:ss.
PFA excel file.
Can someone help me how to achieve this?
Thanks,
Nisha
Are these values in seconds?
QlikView Date & Time functions use a decimal value to represent timestamps, just like in Excel: the integer part represents the date, the fraction is the time as part of a day (ex. 0.25 = 6AM). If you put those values straight into a call to the Time() function (or even better, Interval()), you will get a value in hh:mm:ss.
But just like Kushal asked before, I would like to know too what those values really represent.
What is the actual format for this decimal data please elaborate.
These values are in hh:mm:ss.
I mean data in your excel file is in seconds?
Hi All,
These values are in hh:mm:ss.
Thanks
No they are not. They are just decimals, even in Excel which doesn't format them otherwise. What do they actually represent?
For example, if I format the very last value in Excel into a DateTime value, I get 19/11/6944 10:04:48. Is that correct?
If you don't know the answer to this question, maybe you can tell us where your values come from?
Hello Nisha,
Try this,
time(date#( DecimalValue ,'hhmmss'),'hh:mm:ss') as time
Hope this help!