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.

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" <(E-Mail Removed)> wrote in message
news:CC2D8D75-5E0B-46CE-A299-(E-Mail Removed)...
>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.