Time problems (1 Viewer)

[Douggie]

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

 

[qafself]

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

 

[Douggie]

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

 

[CraigDolphin]

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

 

[Douggie]

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