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:

       

      =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.