Convert Decimal into hh:mm:ss

[Anonymous]

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

[Kushal_Chawda]

Are these values in seconds?

[Peter_Cammaert]

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.

[its_anandrjs]

What is the actual format for this decimal data please elaborate.

[Anonymous]

These values are in hh:mm:ss.

[Kushal_Chawda]

I mean data in your excel file is in seconds?

[Anonymous]

Hi All,

These values are in hh:mm:ss.

Thanks

[Peter_Cammaert]

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?

[Peter_Cammaert]

If you don't know the answer to this question, maybe you can tell us where your values come from?

[rohitraut]

Hello Nisha,

Try this,

time(date#( DecimalValue ,'hhmmss'),'hh:mm:ss') as time

Hope this help!