dilluns, 1 d’agost de 2016

Convert from miliseconds ms to hh:mm:ss libreoffice openoffice

Function
A1=Cell with ms


=TEXT(A1/86400000;"hh:mm:ss")

or from seconds to hh:mm:ss

=TEXT(C140/(24*60*60);"hh:mm:ss")