Format seconds to [hh]:mm:ss

[Anonymous]

Hi guys please can someone tell me how to format a field in time so over 24 hours clocks up the hours if that make sense so hh:mm:ss 25:00:00 should not equal 01:00:00

this is currently the expression that I have tried

Interval(SUM(TalkTime)/86400, 'hh:mm:ss')

Thanks so much

Matt

[sunny_talwar]

Try with Interval() and Interval#() functions

=Interval(Interval#(93600, 'ss'), 'h:mm:ss')

[Anonymous]

Thank you however that just returns a dash/ hyphen –

I am using QlikSense 3.2

[sunny_talwar]

Do you have a comma in your seconds field? May be try this

=Interval(Interval#(KeepChar(93600, '0123456789'), 'ss'), 'h:mm:ss')

P.S. QlikView or Qlik Sense, it should work