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