formula to convert hours, minutes, secs into just seconds

chriscim · May 9th, 2002, 08:39 AM

hi i have to take time at work and
it is like 10:15:25
which is hours minutes and secs
and convert to just seconds
does anyone know a formula to convert to just seconds which would be 36925 in secs

thanks
chris

Aladin Akyurek · May 9th, 2002, 08:42 AM

=A1*86400

Format the formula cell as General.

chriscim · May 9th, 2002, 08:51 AM

thanks
just what i needed
did not think about that
thank you
chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:39 AM	#1
chriscim New Member Join Date: Apr 2002 Posts: 30	hi i have to take time at work and it is like 10:15:25 which is hours minutes and secs and convert to just seconds does anyone know a formula to convert to just seconds which would be 36925 in secs thanks chris

May 9th, 2002, 08:42 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	=A1*86400 Format the formula cell as General.

May 9th, 2002, 08:51 AM	#3
chriscim New Member Join Date: Apr 2002 Posts: 30	thanks just what i needed did not think about that thank you chris