Converting seconds into hh:mm:ss format

[sridhar_sigired]

Hi,

When i check below result in text box

=Time(Time#(Round(86400),'SS'),'hh:mm:ss')

(Ex: =Time(Time#(Round(TotalTimeforCall),'SS'),'hh:mm:ss')

It is showing 00:00:00 format.

However i should get result as 24:00:00

Can anyone help me to get this result?

[sunny_talwar · Accepted solution]

Try with Interval() and Interval#() functions:

=Interval(Interval#('86400','ss'),'hh:mm:ss')

[Peter_Cammaert]

Or - because there are 86400 seconds in a day, and QlikView functions expect the numer of days as a parameter - you can simply divide by 86400. One function call less.