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: 
canmarroig
Partner - Creator
Partner - Creator

Convert a integer number in seconds to dd:hh:mm:ss

I've a integer number in seconds: 4.603.422, that I obtain from an expression and i'd like to transfom in: day:hh:mm:ss

I've tried with number format, but result is 00:00:00, then a tried to use functions like time, timestamp, maketime with or without # but i can achieve my target. Is there a function to solve this trouble or have I to calculate dd:hh:mm:ss concatenating different expression to extract separately day, hours and so on?

Who can help me, pls? Tks in advance

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=interval(interval#(4603422,'ss'),'d hh:mm:ss')

or

=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')

View solution in original post

3 Replies
swuehl
MVP
MVP

Try

=interval(interval#(4603422,'ss'),'d hh:mm:ss')

or

=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')

canmarroig
Partner - Creator
Partner - Creator
Author

I've created a variable with my sum and'ive put it inside expression. Excellent!! Tks

Not applicable

Hi Stefan,this is working perfectly. But, I have customer requirement that, If we download this to excel and select couple if rows, we can only count of the rows but not the sum.

Say I have these values,

03:04:46:45

02:22:18:05

If we select these, excel should show 05:27:04:50 in the right corner bottom of Excel. Help me out in this.

Thanks