Thread: Averaging time
View Single Post
  #1   Report Post  
auccl799 auccl799 is offline
Junior Member
 
Posts: 1
Default Averaging time

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