MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Time Conversion

Posted by Alex Nolan on July 31, 2001 4:18 PM

If you have a time format, ie hh:mm:ss such as 10:14:12
how can you convert this so it is all in seconds? ie:
36852 seconds.

I know I can do this with the hrs, mins, secs in separate columns but to do it from one input would be nice.


Posted by Ian on July 31, 2001 4:53 PM

if 10:14:12 is in cel A1 then in B2 put =A1*86400
format cell to general

hope this helps


Posted by Mark W. on August 01, 2001 8:13 AM

In case you're wondering where Ian came up with
86400. Remember that Excel stores times as
a fractional part of a day (e.g., 12:00 is 0.5).
So to convert a fraction of a day to seconds
you multiply it by...

24 {hr/day} * 60 {min/hr) * 60 {sec/min}

...or 86400