View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jimh jimh is offline
external usenet poster
 
Posts: 3
Default calculate time/distance

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?