New Excel Forum

This forum has been moved to TeachExcel.com

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.

i need help with a formula to calculate MPH

Postby trh44 » Fri Mar 02, 2012 6:00 pm

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

Postby Don » Fri Mar 02, 2012 7:54 pm

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

Postby trh44 » Fri Mar 02, 2012 8:26 pm

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

Postby Don » Fri Mar 02, 2012 8:35 pm

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

Postby trh44 » Fri Mar 02, 2012 8:50 pm

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

Postby Don » Fri Mar 02, 2012 8:56 pm

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

Postby trh44 » Fri Mar 02, 2012 9:08 pm

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

Postby Don » Fri Mar 02, 2012 9:13 pm

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

Postby trh44 » Sat Mar 03, 2012 11:17 am

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

Postby Don » Sun Mar 04, 2012 9:46 pm

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

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

Next

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 30 guests