Recent content by Douggie

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

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

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