Quote:
Originally Posted by auccl799
How do I use excel to find an average time?
I swim and record my time for every 250m I swim. The time is recorded in excel in hh:mm:ss format. How do I find out what my average swim time is per 25 metres?
My spreadsheet looks like this:
Time Distance
Lap 1 00:07:05 250
Lap 2 00:07:17 250
Lap 3 00:07:21 250
Lap 4 00:07:23 250
Thanks for your help
|
Dear auccl799, Good Morning.
You can try this one:
___A______B_________C_________D
1_Lap_____Time_______Distance___Avg per 25 mts__
2_Lap 1____00:07:05___250_______=(B2/10)
3_Lap 2____00:07:17___250_______=(B3/10)
4_Lap 3____00:07:21___250_______=(B4/10)
5_Lap 4____00:07:23___250_______=(B5/10)
6
7____________________AVG TOTAL: =AVERAGE(D2: D5)
Tell me if is worked for you.