i need help with a formula to calculate MPH

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

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
 
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
 
Posts: 653
Joined: Dec 4, 2011
Reputation: 1
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
 
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
 
Posts: 653
Joined: Dec 4, 2011
Reputation: 1
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
 
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
 
Posts: 653
Joined: Dec 4, 2011
Reputation: 1
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
 
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
 
Posts: 653
Joined: Dec 4, 2011
Reputation: 1
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
 
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
 
Posts: 653
Joined: Dec 4, 2011
Reputation: 1
Excel Version: 2010

Next

Return to General Excel Questions

Who is online

Users browsing this forum: Bing [Bot] and 1 guest