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 <4232fe39.3531437@news.verizon.net>,
glenlee@nospam.com (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" <domenic22@sympatico.ca> wrote in message
news:domenic22-BFF18F.09481612032005@msnews.microsoft.com...
> Custom format as...
>
> [s]
>
> Hope this helps!
>
> In article <4232fe39.3531437@news.verizon.net>,
> glenlee@nospam.com (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.