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.