Attached is a simple excel spreadsheet I use to track times & splits.
The first line is a sample data; the yellow highlights is entered while the green is calculated. Enter the date/stroke/distance and subtractive splits, and the cumulative split and final time is calculated. The final time is max from the cummulative splits, to save a little bit of typing. If you don't have splits, you can just enter the final time over the formula.
The time boxes use the custom format m:ss.00. Times must be entered x:xx.xx so excel will recognize them as times.
This is super-sweet. The only thing left is to add the yards/meters conversion formula, which even I can do! Much thanks.
Attached is a simple excel spreadsheet I use to track times & splits.
The first line is a sample data; the yellow highlights is entered while the green is calculated. Enter the date/stroke/distance and subtractive splits, and the cumulative split and final time is calculated. The final time is max from the cummulative splits, to save a little bit of typing. If you don't have splits, you can just enter the final time over the formula.
The time boxes use the custom format m:ss.00. Times must be entered x:xx.xx so excel will recognize them as times.
This is super-sweet. The only thing left is to add the yards/meters conversion formula, which even I can do! Much thanks.
