Convert time to all seconds

[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.

 

[Domenic]

Custom format as...



Hope this helps!

 

[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)

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.