Convert time to all seconds

G

glenlee

I have a time number format as "00:01:02" (hours, minutes, seconds).
How do I convert to show all seconds. For example, the number above
should show as "62" seconds.
 
B

Bob Phillips

Or if you just wanting a separate cell, then

=A1*24*60*60 an format as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)


Domenic said:
Custom format as...



Hope this helps!

I have a time number format as "00:01:02" (hours, minutes, seconds).
How do I convert to show all seconds. For example, the number above
should show as "62" seconds.
Click to expand...
Click to expand...
 
Top