How can I figure average MPH?

[Guest]

I bike race and like to keep track of average speed of the races. I'd like
to set up a template in Excel that I can easily enter the time and distance
and let the spreadsheet do the figuring. I have a template now, but have to
enter many different numbers to convert the time to decimal numbers and the
formulas are long and cumbersome.

 

[Tushar Mehta]

If you have the miles biked in column A starting with A2 and the time
for each distance in B, then in C2 enter =SUM($A$2:A2)/SUM($B$2:B2)/24.
Drag this down column C for as many races as you have. It gives the
unweighted average for all races in rows 2:n.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions