• Registered: 2018-07-02
  • Posts: 266

Topic: Anybody know how to format race lap times in Excel for calculations?

I downloaded our race lap data into Excel from Race Monitor and want to play around with averages, and other misc BS.

However, when I try to do this Excel doesn't understand how to perform calculations (averages, sums, etc) based on the lap time format.

MM:SS.000 (where the 0's represent a tenth/hundreth/thousandth of a second)

So an example lap time would be: 1:55.356

Anybody gone through this?  I have been messing with it for a little while with no luck.

2018 Where the Elite Meet to Cheat - Organizer's Choice Award
2019 Rust Belt GP - Spirit of Entropy Award
2019 The Tony Swan Never-Say-Die Memorial - Index of Effluency Award
2020 The Tony Swan Never-Say-Die Memorial - Class C Lap Winner

2 Reply by Bayley (edited by Bayley 2019-10-18 08:34 AM)

  • From: Orion Twp, MI
  • Registered: 2011-04-18
  • Posts: 776

Re: Anybody know how to format race lap times in Excel for calculations?

https://i.imgur.com/WOcgHru.jpg

Just set it up as a custom format and you should be able to do whatever you need to with it.

The Pentastar whisperer

Bayley's Website

  • From: Elverson, PA
  • Registered: 2017-08-15
  • Posts: 1,128

Re: Anybody know how to format race lap times in Excel for calculations?

https://support.office.com/en-us/articl … 12cd57334f

... and more information if you need it...

  • From: Somewhere in CA...
  • Registered: 2017-10-26
  • Posts: 196

Re: Anybody know how to format race lap times in Excel for calculations?

Just to serve as a reference point as to what's possible: we have a mathematician on our team. I dump all the lap times into Excel and break things out by driver, throw out the stops and yellows. Then he takes over. Using some crazy statistics program, perhaps Python, and he produced this from Butt Turrible:

https://photos.smugmug.com/Cars/Lemons/i-8D8hPtn/0/2f029fde/L/TimebyDriver-ButtTerrible2019-L.jpg

These are our times in the Kim Jong Elantra.

--Bill