Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I would like to convert seconds to DD hh:mm:ss. The method I'm using is the next:
=time([MyTime]/86400,'hh:mm:ss')
That method only shows hh:mm:ss. If I try with adding DD to the method it always appears to me that there are 30 days.
=time([MyTime]/86400,'DD hh:mm:ss')
Someone can help me to get the correct days of my time in seconds.
Thank you.
May be try with Interval
=Interval([MyTime]/86400,'D hh:mm:ss')
Many thanks Sunny, with your message I have been able to fix it.
How can I add string ' days' after number of days with this calculation??