calculate elapsed time given mph and distance

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

Guest

Can anyone please tell me how in Excel to calculate elapsed time given mph and distance?
 
Time = Distance/Rate

A1: 60 (MPH)
A2: 420 (miles)

A3: =A2/A1 ==> 7 (hours)
 
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

In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
Calculate elapsed time excluding specific timeframe 10
Calculating Time from Speed and Distance? 3
Puzzled by simple MPH calculation? 1
Four User Defined Functions - probably one similar answer 7
How to calculate speed given distance and mm:ss time format? 1
Calculating Elapsed Time 2
How to use miles per hour and mileage to estimate travel time 1

Back
Top