# New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

## i need help with a formula to calculate MPH

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### i need help with a formula to calculate MPH

Lets say a ball is rolling and it passes by point A at 13:30:25 (Cell A2) it keeps rolling 1 mile (Cell C2) and it passes point B at 13:45:30 (Cell B2). I need help with a formula to calculate MPH (Cell D2)
All of my attemts for this formula have been unsuccessfull.
Thanks Travis
• 0

trh44
Rookie

Posts: 10
Joined: Feb 27, 2012
Reputation: 0
Excel Version: 2007

### Re: i need help with a formula to calculate MPH

Gotta love school math problems lol.

Try this:

Code: Select all
`=60/((B2-A2)*1440)`
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

### Re: i need help with a formula to calculate MPH

Don wrote:Gotta love school math problems lol.

Try this:

Code: Select all
`=60/((B2-A2)*1440)`

Where does the distance fit into the eqation?
• 0

trh44
Rookie

Posts: 10
Joined: Feb 27, 2012
Reputation: 0
Excel Version: 2007

### Re: i need help with a formula to calculate MPH

If it takes 15 minutes and 5 seconds to travel one mile. How many miles per hour is that? How many miles can you travel in one hour or 60 minutes? Remember that MPH is just Miles Per Hour which is just a calculation of how many miles you can travel in one hour at a set speed. And, you know there are 60 minutes in an hour and it takes 15 minutes and 5 seconds to travel the 1 mile. So, it's just 60/15.083. If it was a distance of 2 miles traveled in that time, you would just multiple the result of the calculation by 2.
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

### Re: i need help with a formula to calculate MPH

What i have done to make the equation work is, take the product of the difference in the two times and multiply them by 24 to express the time as a number. "this was all done in excel" i took the difference in the two times expressed as a number example 1.24 and divided the distance by time to calculate mph. i have had to do all of this in three different cells to get the correct mph. i would like to get it all down to just one formula.
• 0

trh44
Rookie

Posts: 10
Joined: Feb 27, 2012
Reputation: 0
Excel Version: 2007

### Re: i need help with a formula to calculate MPH

So, use the one I gave you... What's wrong with that? Or, include the worksheet where you have the separate cells and it will be easy to combine them.
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

### Re: i need help with a formula to calculate MPH

Ok i have it working i took
=distance/((point A passage time-point B passage time)*24)
it works now thank you for your help and time
• 0

Last edited by trh44 on Sun Mar 04, 2012 10:19 pm, edited 1 time in total.
trh44
Rookie

Posts: 10
Joined: Feb 27, 2012
Reputation: 0
Excel Version: 2007

### Re: i need help with a formula to calculate MPH

What result did you get?
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

### Re: i need help with a formula to calculate MPH

trh44 wrote:Ok i have it working i took
=distance/((point A passage time-point B passage time)*24)
it works now thank you for your help and time
• 0

trh44
Rookie

Posts: 10
Joined: Feb 27, 2012
Reputation: 0
Excel Version: 2007

### Re: i need help with a formula to calculate MPH

No, I meant, what final MPH did you get?
• 0

Don
Moderator

Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

Next