
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Convert Decimal into hh:mm:ss
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are these values in seconds?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the actual format for this decimal data please elaborate.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
These values are in hh:mm:ss.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I mean data in your excel file is in seconds?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All,
These values are in hh:mm:ss.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you don't know the answer to this question, maybe you can tell us where your values come from?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Nisha,
Try this,
time(date#( DecimalValue ,'hhmmss'),'hh:mm:ss') as time
Hope this help!

- « Previous Replies
-
- 1
- 2
- Next Replies »