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

[kkkumar82]

Hi Wilson,

Can you a sample example with one or two dates , what are you looking for? It helps for understanding the issue

[gerry_hdm]

hello

so ?

Interval( 1/24/60/60*sum(sumsecond) ,'hh:mm:ss') as TIME

Interval(1/24/60/60 * SUM(TalkTime), 'hh:mm:ss') as yourvar

Gerry

[Anonymous]

I get an error with that and I am sure it would yield the same result

so what I am after is the expression so if I have an integer of 93,600 (seconds in 26 hours it should return) 26:00:00

[gerry_hdm]

send a example from your input

greetings Gerry

[Anonymous]

so what I am after is the expression so if I have an integer of 93,600 (seconds in 26 hours it should return) 26:00:00

[gerry_hdm]

probiere das

Interval(  1/24/60/60 * TalkTime,'hh:mm:ss') as yourVar

🙂

gruß Gerry

[Anonymous]

Thank you sir, I had already fixed the field name, though it still returns (if you go over 24) hours time as opposed to :mm:ss

[gerry_hdm]

Hello Matt

if this correct answer then close the tread.

Excuse me for my bad english

danke Thanks greetings

Gerry

[Anonymous]

Thank you but is isnt