Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Wilson,
Can you a sample example with one or two dates , what are you looking for? It helps for understanding the issue
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
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
send a example from your input
greetings Gerry
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
probiere das
Interval( 1/24/60/60 * TalkTime,'hh:mm:ss') as yourVar
🙂
gruß Gerry
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
Hello Matt
if this correct answer then close the tread.
Excuse me for my bad english
danke Thanks greetings
Gerry
Thank you but is isnt