topic Re: Convert hours in decimals to hh:mm:ss in QlikView

Convert hours in decimals to hh:mm:ss

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I need convert this expression in a chart: sum([Seconds]/3600) -> (Show data in hours) to 'hh:mm:ss' format.

Can you help me please?

sunny_talwar — Wed, 01 Mar 2017 16:46:38 GMT

Use Time(sum([Seconds]/3600)) may be

mromrod22 — Wed, 01 Mar 2017 16:52:04 GMT

Hi Sunny,

Now show 2:18:24 AM... this not correct. The expected output is 18:05:46 (18.10 hours).

In the format settings I checked "Time"

sunny_talwar — Wed, 01 Mar 2017 16:54:36 GMT

How about this

Interval(Sum(Seconds), 'hh:mm:ss')

sunny_talwar — Wed, 01 Mar 2017 16:54:49 GMT

Interval(Sum(Seconds/3600), 'hh:mm:ss')

MarcoWedel — Wed, 01 Mar 2017 23:38:58 GMT

maybe you can change the expression number format to "Interval":

You would have to divide your expression by 24 hours/day as well to get the correct result, i.e.

sum([Seconds]/86400)

hope this helps

regards

Marco