seconds to hour/minutes/seconds

[#1]

I got workhours in seconds 3890478 sec.

Now this most be in 00:00:00

how can I do this ?

thx

[#2]

Devide your seconds by 86400 and format with the time format codes.

time(<your seconds>/86400, 'hhh:mm:ss')

[johnw]

Time() is limited to a 24 hour clock, so I'm guessing we want interval(Seconds/86400,'hh:mm:ss') instead. Obviously the same basic idea, though. Divide by 86400, tell qlikview it is an interval of time, and format as desired.