topic Converting Seconds to hh:mm - problem in QlikView

Converting Seconds to hh:mm - problem

Fri, 26 Jun 2015 11:37:34 GMT

Hi , I have a '[Difference Seconds]' field that totals to :125040

If I use the following expression to try and convert this to hh:mm:ss :

=sum(Time(Time#([Difference Seconds],'ss'),'hh:mm:ss'))

the output is 10:44:00. The actual hh:mm that should be displayed is around 34 hours. Can anyone help to get the correct output?

Thanks,

Tom

swuehl — Fri, 26 Jun 2015 11:41:23 GMT

Use interval() and interval#() instead of Time() / Time#().

=Interval#(sum([Difference Seconds]),'ss'),'hh:mm:ss')

MK_QSL — Fri, 26 Jun 2015 11:45:07 GMT

=Interval(125040/(3600*24),'hh:mm:ss')

alexandros17 — Fri, 26 Jun 2015 11:45:57 GMT

=Text(Div(125040,3600)) & ':' & Text(Div(125040 - Div(125040,3600) * 3600 , 60))