Forum Discussion
Convert race results to useable format
Hi! Struggling to convertan excel spreadhseet with triathlon race times. The spreadsheet is a conversion from a PDF. The file looks like this: Participant Swim Bike Run TOTAL x...
If you enter the times manually, you append ".0" (or whatever fractional seconds are in the race results), and format as [mm]:ss . For example, 5:47.0 instead of 5:47.
If you must copy-and-paste data in the form min:sec, which Excel interprets as h:m, you can convert the data afterwards, as follows....
Suppose the individual times for swim, bike and run are in B2:D2. Enter 60 into any unused cell, and copy that cell. Then select B2:D2 and paste-special-divide. Then format B2:D2 as [mm]:ss .
Also, format the cell with =SUM(B2:D2) as [mm]:ss .
But don't format to include your transition times. They factor into the total.