Convert hours in decimals to hh:mm:ss

[mromrod22]

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]

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

[mromrod22]

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]

How about this

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

[sunny_talwar]

or

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

[MarcoWedel · Accepted solution]

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