Calculate Miles per hour

I am trying to calculate MPH for a running spreadsheet and having issues...
lets say i run 2.9 miles in 0:34:18 i want to know what the speed i was running for the distance (should be something like 5.1mph). I am sure that it is really easy i just cant figure out how to do it.
Thanks in advance!

Hi,

Say A1 = Miles , B1 = Time enter this in C1

=(A1/B1)/24

Formatted as General

VBA Noob

The formula you are looking for is
3600/time in seconds * distance

or
3600/2058*2.9

or 1.7492*2.9

or 5.0728 MPH

hope this helps

klarzy

Thanks guys! both those worked!

No Problem

VBA Noob

Originally Posted by anwittin

I am sure that it is really easy i just cant figure out how to do it.

For the record, the problem you are having is that excel stores time as a fraction of a day. If you enter 0:34:18 into a cell, then format the cell as General, you will notice a decimal number 0.026875 which is the fraction of a day that 0:34:18 represents. So if you times this by 24, you will get the number of hours = 0.645 which is what you need to work out your formula.