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: 
shannoypaul
Creator
Creator

How to convert Duration in seconds to HH:MM:SS?

I have a column with data only in seconds for e.g. 5402s
This I want to split it as 01:30:02 i.e 1 Hour 30 Minutes 2 Seconds.

Thanks in advance!

Best Regards,

Shannoy

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

=interval(timestamp#(5402, 's'), 'hh:mm:ss')

Regards

ASHFAQ

View solution in original post

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

=interval(timestamp#(5402, 's'), 'hh:mm:ss')

Regards

ASHFAQ

Anonymous
Not applicable

=Time(5402/24/60/60,'hh:mm:ss')

MarcoWedel

=Interval(5402/86400)