| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
time/distance calculation
how do I set up a calculation for time/distance. For instance, if 6 miles per
hour and you have .5 miles to go-what is the time in decimal? |
|
#2
|
|||
|
|||
|
In minutes...
=(Length*60)/MPH = (.5 * 60) / 6 = 5 minutes As a decimal of an hour... =Length/MPH = .5 / 6 = .083333 HTH, Gary Brown "KJO" wrote: how do I set up a calculation for time/distance. For instance, if 6 miles per hour and you have .5 miles to go-what is the time in decimal? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
