ExcelBanter - How do I convert laptimes (mm:sec.ms) into seconds?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I convert laptimes (mm:sec.ms) into seconds? (https://www.excelbanter.com/excel-worksheet-functions/22032-how-do-i-convert-laptimes-mm-sec-ms-into-seconds.html)

Nishant

How do I convert laptimes (mm:sec.ms) into seconds?

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.

Peo Sjoblom

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.

Niek Otten

=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.

All times are GMT +1. The time now is 02:42 AM.