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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating speeds in mph 8
Cumulative days roll-over 7
Calculating Average Speed in Excel 4
time/distance calculation 1
Need your help please , complex issue 4
time format from hh:mm:ss to h:mm 2
Calculating the distance customers live from a branch office 5
Calculating Time from Speed and Distance? 3

Back
Top