I am a swimming coach and I am trying to work out some average times. I have given the swimmers a timed 15 minute swim and recorded how far they have swam. I want the spreadsheet to work out the average time for each 100m swum.
Please help
Ian

Its quite simple

Divide the time by the distance and multiply the result by 100

e.g. if cell C1 contains the distance swum
in cell D1 put =15*100/C1 - this is the number of minutes to swim each 100 on average

Ed

I have tried this but in some of the cells I get 1.77. I need to convert this percentage into minutes and seconds.

D1 put =(100*15/C1)/1440
then change the format of the cell D1 to Time (eg., 37:30:15)

Thanks to both of you. This is now working fine.