2 Replies Latest reply: Apr 26, 2017 12:43 PM by Iñigo Garcia RSS

    Convert seconds to days hours minutes and seconds

    Iñigo Garcia

      Good morning,


      I would like to convert seconds to DD hh:mm:ss. The method I'm using is the next:




      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.