how do i convert standard time format into seconds?

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

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

HTH
--
AP

"Raj" <[email protected]> a écrit dans le message de news:
[email protected]...
>I need to convert standard time format(hh:mm:ss) into seconds. Do we have
>any
> formula to do this in excel.

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.

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.

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.