View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default calculate time/distance

=distance/mph*60 in minutes

--

HTH

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


"KJO" wrote in message
...
I need to calculate time in miles per hour. ie:

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