Hi there all, I've tried doing this but I am far away from being an expert with spreadsheets. I am starting to run and I want to record my times to see if I am improving. Its a very simple spreadsheet. Distance (in miles) Time (in minutes) Time in minutes per mile My problem is that say I did 2.6 miles in 20 minutes and 30.03 seconds and i enter this in the formula as 20.3003 / 2.6 it doesn't give a correct answer as time is based on 60 not 100. 20.3003 doesn't translate directly into a decimal as 20.3003.... In other words do I need to convert 20 mins and 30.03 seconds into decimal ie....something like 20.5 (30 seconds being 0.5 of a minute) or is there a built in formula that I can use....?!? My brain hurts....as well as my legs!