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.

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.

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.

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.