While cycle training over winter I need to store data of average speeds on a spreadsheet to monitor fittness.?

I am relatively new to Excel and need a simple layout for data input such as 3 columns A, B and result in C. Distance (decimal miles) in A, time (hrs, mins, secs) in B and average speed (as 00.00 mph) in C. Would any kind person be able to offer suggestions for layout and cell/column formula so I am able just to enter date in columns A and B. I need accuracy to 2 decimal places to monitor progress for a 'same-distance ride' at the end of each week.

While cycle training over winter I need to store data of average speeds on a spreadsheet to monitor fittness.?
Put your titles in A1 - Miles, B1 - Time and C1 - Average speed


Paste your data starting with A2, B2 and C2





Right click and choose formats on the the first data cell(A2) choose the numbers tab and make the format for to numbers and 2 decimal places, change your formats on your second and third cells (B2, C2) to time and choose whichever time format you like the look of.





For C2, paste in the following formula


= A2/B2, then copy and paste that formula down





If you want an overall average, hit the sum button and sum column A, do the same to column b and then paste your formula in column c.





So if you went 10 miles in 5 minutes, it would look like this





Miles...........................Time..... Time


10................................ ..5....................=A2/B2


.....................................(or 2 minutes is what it will show you)





Hope this helps.
Reply:i am not sure of your formula to get your speed---but in column A you would enter your miles and got to format and set your General decimal to 2 places.


Column B would be formated to Time (hr:min:sec)


Column C would again be General with 2 decimal places.





A B C


distance time Speed


10.00 1:30:45 20.00








good luck :)