How do I get speed given time (hh:mm:ss) and distance in Excel?
 

I have marathon times in hh:mm:ss format and want to get the miles/hour
speed, where miles is 26.2. How do I do that? I have Excel 2003.

How do I get speed given time (hh:mm:ss) and distance in Excel?
 

In Excel, time is a fraction of a day. So each hour is 1/24 of a day. To get
hours from a time, multiply by 24. If your time is in A1, the formula is:

=26.2/(a1*24)

or more accurately, as a marathon is actually 26 miles, 385 yards:

=(26+385/1760)/(a1*24)

--
Regards,
Fred


"Charlie_007" wrote in message
...
I have marathon times in hh:mm:ss format and want to get the miles/hour
speed, where miles is 26.2. How do I do that? I have Excel 2003.