| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating speed
I run a mile in 8:40 (I5) in [m]:ss format
How do I calculate my speed? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating speed
Try this:
distance/(time[hh:mm:ss]*24) Format the formula cell as number -- hth "Robbie1299" wrote: I run a mile in 8:40 (I5) in [m]:ss format How do I calculate my speed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Time from Speed and Distance? | Excel Worksheet Functions | |||
| Is there any way to speed this up? | Excel Programming | |||
| Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS! | Excel Programming | |||
Hybrid Mode
