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")


Comentaris

Entrades populars d'aquest blog

Export data from Xiaomi miband 2 (Mi Fit) to csv (Excel).