Convert time to all seconds
 

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.

Custom format as...

[s]

Hope this helps!

In article ,
(glenlee) wrote:

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.

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" wrote in message
...
Custom format as...

[s]

Hope this helps!

In article ,
(glenlee) wrote:

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.