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

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 fitness?
A1 enter miles


B1 enter hours


C1 enter minutes


D1 enter seconds


E1 =ROUND(((B1/3600+C1/60+D1)/3600)*A1,2)
Reply:A1 enter Miles, say 100 miles


B1 enter time, say 1:15:30


C1 enter =ROUND(A1/(B1*24),2)


in C1 the value return from the formula will be 79.47, if you want to have units on the figure


C1 enter =ROUND(A1/(B1*24),2)%26amp;" mph"


then you will get 79.47 mph
Reply:You should find this cycling website helpful http://www.professionalcycling.info/