| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
stopwatch average per mile
I'm trying to come up with the avg/mile for race times. Is there a formula or
setting that needs to be used? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
stopwatch average per mile
Assume you have 10 miles in A1 and 00:35:25 (35 minutes and 25 seconds) in
B1 =B1/A to get the average time per mile = -- Regards, Peo Sjoblom "JBT" wrote in message ... I'm trying to come up with the avg/mile for race times. Is there a formula or setting that needs to be used? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
stopwatch average per mile
so.. do we assume you have, say, distance travelled and time travelled?
Let's say x is your distance and y is your time y/x = time to travel your distance. If x is in feet, (y/x)*5280 gives time per mile. Otherwise, could you give further details? "JBT" wrote: I'm trying to come up with the avg/mile for race times. Is there a formula or setting that needs to be used? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does anyone know how to create a pace calculator (min/mile) in Exc | Excel Discussion (Misc queries) | |||
| Average minutes per mile | Excel Worksheet Functions | |||
| Formula or Function providing Mile value in a cell from 2 addresse | Excel Worksheet Functions | |||
| Mile value | Excel Worksheet Functions | |||
| Stopwatch | Excel Worksheet Functions | |||
Linear Mode
