Convert Seconds to Hour-Minute-Second in Excel

Sometimes when doing time related calculation, the final values are in second.

For example, downloading a 369,300 byte file with a speed of 100 byte/second, the time required is 3693 seconds. Then, what is the hour-minute-second of 3693 seconds ?

Using Excel, there is a formula called time(). Put this formula into a cell :

=time(0,0,3693)

Then, format the cell with :

hh:mm:ss

The cell will display 01:01:33 (i.e. 1 hour 1 minute and 33 seconds).

---