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.
Thanks
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
Ian
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
