Convert time to running pace per mile

[JRandell]

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.

 

[Norman Jones]

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

 

[Gary Keramidas]

when i divide 20:10 by 3, i get 6:43

 

[JRandell]

You are correct. Sorry for any confusion.

JR

when i divide 20:10 by 3, i get 6:43