Convert seconds to days hours minutes and seconds

[#1]

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.

[sunny_talwar · Accepted solution]

May be try with Interval

=Interval([MyTime]/86400,'D hh:mm:ss')

[#3]

Many thanks Sunny, with your message I have been able to fix it.

[balajikannan2013]

How can I add string ' days' after number of days with this calculation??