Excel Formula Issue

**RichardLeeds** · 05-05-2015, 06:41 AM

Trying without success to calculate average MPH for 27.81 miles in 1:56.00. Any assistance would be appreciated.

Best Regards

**zbor** · 05-05-2015, 06:51 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**joeu2004** · 05-05-2015, 12:07 PM

Originally Posted by RichardLeeds

Trying without success to calculate average MPH for 27.81 miles in 1:56.00. Any assistance would be appreciated.

First, I think it would be prudent to describe the time in English.

As you wrote it (a typo?), Excel interprets that as 1 min 56 sec. But I doubt the average speed was more than 863 MPH.

I suspect you mean 1 hr 56 min. That should be written 1:56 or 1:56:00, at least in my region. (Regional differences might apply; but I doubt it in this case.)

If A1 is distance in miles (27.81) and B1 is time (1:56), MPH can be calculated by:

=A1/A2/24

A1/A2/24 is another way of writing A1/(A2*24). We multiply A2 by 24 because Excel time is stored as a fraction of a day. So 1 hr, written 1:00, is stored as 1/24.