calculate time/distance

I need to calculate time in miles per hour. ie:

6 miles per hour-travel .5 miles = what decimal amount of time?

Divide the speed (MPH) by the distance traveled:
travel time time
spd/mph miles hours minutes
6 0.5 0.083333 5
6 1 0.1666667 10
6 12 2 120
6 24 4 240

JimH

"KJO" wrote:

> I need to calculate time in miles per hour. ie:
>
> 6 miles per hour-travel .5 miles = what decimal amount of time?

Whoops, divide the distance traveled by the speed; data posted is correct

"JimH" wrote:

> Divide the speed (MPH) by the distance traveled:
> travel time time
> spd/mph miles hours minutes
> 6 0.5 0.083333 5
> 6 1 0.166667 10
> 6 12 2 120
> 6 24 4 240
>
> JimH
>
> "KJO" wrote:
>
> > I need to calculate time in miles per hour. ie:
> >
> > 6 miles per hour-travel .5 miles = what decimal amount of time?

=distance/mph*60 in minutes

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KJO" <KJO@discussions.microsoft.com> wrote in message
news:ECA51B89-1050-4397-9C22-AAB74ADA4741@microsoft.com...
> I need to calculate time in miles per hour. ie:
>
> 6 miles per hour-travel .5 miles = what decimal amount of time?