Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Format seconds to [hh]:mm:ss

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

12 Replies
kkkumar82
Specialist III
Specialist III

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
Creator II
Creator II

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
Not applicable
Author

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
Creator II
Creator II

send a example from your input

greetings Gerry

Anonymous
Not applicable
Author

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
Creator II
Creator II

probiere das

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

🙂

gruß Gerry

Anonymous
Not applicable
Author

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
Creator II
Creator II

Hello Matt

if this correct answer then close the tread.

Excuse me for my bad english

danke Thanks greetings

Gerry

Anonymous
Not applicable
Author

Thank you but is isnt