how do i convert standard time format into seconds?

Raj · May 29, 2006

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

Ardus Petus · May 29, 2006

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

HTH

Toppers · May 29, 2006

Format cell as [ss]

Gary''s Student · May 29, 2006

Format > Cell... > Number > Custom and enter

Raj · May 29, 2006

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