| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate time/distance
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES | Excel Worksheet Functions | |||
| How to calculate minimum distance between three coordinate with ex | Excel Discussion (Misc queries) | |||
| Can excel calculate Mahalanobis distance? | Excel Discussion (Misc queries) | |||
| How to calculate speed given distance and mm:ss time format? | Excel Discussion (Misc queries) | |||
| CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS | Excel Worksheet Functions | |||
Linear Mode
