I am using the most recent version of Excel. I would like to convert
laptimes (mm:sec.ms) into seconds for the purpose of graphing.

Hi

Multiply your times (if they are Excel times) by 24 (hours in a day) then 60
(minutes in an hour) and then 60 (second in a minute) - which is *86400 in
total. Format the result as a number - not time.

--
Andy.


"Nishant" wrote in message
...
I am using the most recent version of Excel. I would like to convert
laptimes (mm:sec.ms) into seconds for the purpose of graphing.

Multiply time value with 86400 (24*60*60) to get decimal seconds


--
Regards,

Peo Sjoblom


"Nishant" wrote in message
...
I am using the most recent version of Excel. I would like to convert
laptimes (mm:sec.ms) into seconds for the purpose of graphing.

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Nishant" wrote in message
...
I am using the most recent version of Excel. I would like to convert
laptimes (mm:sec.ms) into seconds for the purpose of graphing.