Excel Swim Log Template?

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.

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.