Community and Support

            Formula to convert Milliseconds to Days, Hours, Minutes and Seconds

            When any time value is represented in milliseconds, it can be converted to human readable format as below.

            1000000000 milliseconds can be converted to 11Days 13Hours 46Minutes 40Seconds. The column 'Time in MS' in the formula can be replaced with the respective time column.


            Formula:
            concat(floor("Time in MS"/(1000*60*60*24)),' days ',floor(Mod("Time in MS", 24*60*60*1000)/(60*60*1000)),' hours ',floor(mod(Mod("Time in MS", 24*60*60*1000),(60*60*1000))/(60*1000)),' minutes ',floor(Mod(mod(Mod("Time in MS", 24*60*60*1000),(60*60*1000)),(60*1000))/1000),' seconds')

            Sample  Output:



            Updated: 05 Apr 2018 11:39 PM
            Helpful?  
            Help us to make this article better
            0 0