EXCEL : Formula to get DATE/TIME [request]

[andre_luis]

Hi Friends,


How could I convert an Integer number wich represents SECONDS, to the YY/MM/DD - HH:MM:SS format ?

For instance, I know that 0/0/2 - 04:23:17, is equivalent to 188.597s.
However, the inverse operation, I don´t know how to do.

Anybody have some sugestion ?


+++

 

[tpetar]

https://excelsemipro.com/2010/08/convert-seconds-to-a-time-format-in-excel/

 

[betwixt]

Caution - Micro$oft calculate the time in a different way to Unix/Linux and most other OS. If you are transferring time data between systems make sure you don't mix them up.

Brian.