Convert seconds into HH:MM:SS
Posted by Santos on November 14, 2001 10:18 AM
Is there a formula to convert seconds into hh:mm:ss?
Can someone give me an example?
Thanz......
Jsantos
Posted by Dan on November 14, 2001 10:29 AM
If the data in seconds is in A1, in another cell such as B1 type:
=A1/86400
And format B1 as hh:mm:ss
Posted by Santos on November 15, 2001 1:57 AM
Ok. Thankz Dan, is very simple, i was tring some formulas in excel but, it comes to be very simple
