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

[effinty2112]

Hi Satya,

Here's another way:

= Replace(

Replace(

Replace(

Replace(

Interval(20400062/24/60/60,'dd U hh V mm X ss Z')

,'U', 'Days'),

'V', 'Hr'),

'X','Min'),

'Z', 's')

returns:

236 Days 02 Hr 41 Min 02 s

Regards

Andrew

[SatyaPaleti]

Thank you Andrew

[Anonymous]

Simple but effective!!