Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thank you Andrew
Simple but effective!!