how do i convert standard time format into seconds?

[Raj]

I need to convert standard time format(hh:mm:ss) into seconds. Do we have any
formula to do this in excel.

[Ardus Petus]

=A1*24*60*60
or:
=A1*86400

HTH
--
AP

"Raj" <Raj@discussions.microsoft.com> a écrit dans le message de news:
938D6BC6-21CD-4ADB-88C3-CD0C5D205096@microsoft.com...
>I need to convert standard time format(hh:mm:ss) into seconds. Do we have
>any
> formula to do this in excel.

[Toppers]

Format cell as [ss]

"Raj" wrote:

> I need to convert standard time format(hh:mm:ss) into seconds. Do we have any
> formula to do this in excel.

[Gary''s Student]

Format > Cell... > Number > Custom and enter [s]
--
Gary's Student


"Raj" wrote:

> I need to convert standard time format(hh:mm:ss) into seconds. Do we have any
> formula to do this in excel.

[Raj]

Thanks Ardus,Toppers and Gary''s Student it worked. Thanks once again

"Raj" wrote:

> I need to convert standard time format(hh:mm:ss) into seconds. Do we have any
> formula to do this in excel.