| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert time to running pace per mile
I am trying to define a forumla that will, based on the time (e.g. 20:32)
entered into one cell, will calculate the running "pace per mile" in another cell automatically. An example would be: If I ran 3 miles in 21 minutes that would equal a 7 minute mile pace. or If I ran 3 miles in 20:10 minutes that would equal a 6:46 minute mile pace. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert time to running pace per mile
Hi J,
I do not see an obvious programming connotation to your question. However, Speed = Distance / Time, so try: A1: = Distance B1 = Time C1 =A1/B1 --- Regards, Norman "JRandell" wrote in message ... I am trying to define a forumla that will, based on the time (e.g. 20:32) entered into one cell, will calculate the running "pace per mile" in another cell automatically. An example would be: If I ran 3 miles in 21 minutes that would equal a 7 minute mile pace. or If I ran 3 miles in 20:10 minutes that would equal a 6:46 minute mile pace. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert time to running pace per mile
when i divide 20:10 by 3, i get 6:43
-- Gary "JRandell" wrote in message ... I am trying to define a forumla that will, based on the time (e.g. 20:32) entered into one cell, will calculate the running "pace per mile" in another cell automatically. An example would be: If I ran 3 miles in 21 minutes that would equal a 7 minute mile pace. or If I ran 3 miles in 20:10 minutes that would equal a 6:46 minute mile pace. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert time to running pace per mile
You are correct. Sorry for any confusion.
JR "Gary Keramidas" wrote: when i divide 20:10 by 3, i get 6:43 -- Gary "JRandell" wrote in message ... I am trying to define a forumla that will, based on the time (e.g. 20:32) entered into one cell, will calculate the running "pace per mile" in another cell automatically. An example would be: If I ran 3 miles in 21 minutes that would equal a 7 minute mile pace. or If I ran 3 miles in 20:10 minutes that would equal a 6:46 minute mile pace. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formual for calculating running pace? | Excel Worksheet Functions | |||
| convertion formula for (min/mile) to (mile/hr) | Excel Discussion (Misc queries) | |||
| how do I convert pace per mile to total time in minutes in excel? | Excel Discussion (Misc queries) | |||
| Does anyone know how to create a pace calculator (min/mile) in Exc | Excel Discussion (Misc queries) | |||
| How do I calculate running pace? | Excel Worksheet Functions | |||
Hybrid Mode
