topic Re: Converting seconds into hh:mm:ss format in QlikView

Converting seconds into hh:mm:ss format

sridhar_sigired — Mon, 17 Oct 2016 13:51:55 GMT

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?

Re: Converting seconds into hh:mm:ss format

sunny_talwar — Mon, 17 Oct 2016 13:54:15 GMT

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

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

Re: Converting seconds into hh:mm:ss format

Peter_Cammaert — Mon, 17 Oct 2016 14:04:22 GMT

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.