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

[SatyaPaleti]

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

[prma7799]

try like this

Convert Seconds into Hours | Qlik Community

[SatyaPaleti]

Thank you. But I require in days

[prma7799]

try like this;

secondsfeild/360 this will convert hrs

Days conversion:

(secondsfeild/360)/8 as days

[tresesco]

Try like:

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

[pradosh_thakur]

try this

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

or

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

[Anonymous]

HI,

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

its worked fine

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

Regards

Sahadev

[SatyaPaleti]

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]

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]

Did you try Tresco's expression like

just changed 24 to 8 hours.

=Floor(20400062/60/60/8)