Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to convert seconds in to DD:HH:MM:SS format

Hi Folks,

How can we convert seconds in to DD:HH:SS format

for example I am having 20400062 seconds. How can we show this in to Days Hours Minutes seconds format  DD:HH:MM:SS

Could you please help on this

Thanks and Regards,

Satya

22 Replies
prma7799
Master III
Master III

SatyaPaleti
Creator III
Creator III
Author

Thank you. But I require in days

prma7799
Master III
Master III

try like this;

secondsfeild/360 this will convert hrs

Days conversion:

(secondsfeild/360)/8 as days

tresesco
MVP
MVP

Try like:

=Floor(20400062/60/60/24) &' Days '  & Interval(frac(20400062/60/60/24),'hh:mm:ss')

pradosh_thakur
Master II
Master II

try this

=Interval([time_field]/86400,'DD:hh:mm:ss')


or


=Interval(20400062/86400,'DD:hh:mm:ss')

Learning never stops.
Anonymous
Not applicable

HI,

I have  used following expression to get DD:HH:MM:ss format

its worked fine

=timestamp(20400062,'DD:HH:MM:ss') 

DD_HH_MM_ss _.PNG

Regards

Sahadev

SatyaPaleti
Creator III
Creator III
Author

Thank you so much Mahadev

I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this

SatyaPaleti
Creator III
Creator III
Author

Thank you so much Thakur

I have a requirement. the above number(20400062) I have shown is in Minutes I want to convert Minutes in to Days. But day have only 8 hours. How can we do this

vishsaggi
Champion III
Champion III

Did you try Tresco's expression like

just changed 24 to 8 hours.

=Floor(20400062/60/60/8)