what is the formual for calculating running pace?

[TonyM]

I am trying to compile a spreadsheet that can work out my running pace, i.e.
how long it would take to run a mile based on the time taken to run a
distance entered. I know how to work this out manually but do not know how to
configure a spreadsheet to do this automaticaly.

 

[John Michl]

Try this.
A1 enter the Distance already run in miles
A2 enter the Time in minutes to run A1
A3 enter formula = A2/A1 which yields minutes to run full mile.

- John Michl
www.JohnMichl.com/exceltips.htm

 

[Gary L Brown]

If TIME in hrs/minutes/seconds (ex: 00:32:00) is in cell A2 and DISTANCE in
miles (ex: 4.00) is in B2 then Time/Mile in C2 can be...
=A2/B2*60*24
calculates out to 8 for 8 minutes per mile


Format the TIME column to hh:mm:ss
Format the DISTANCE column to 0.00
Format the Time/Mile column to 0.00

HTH,

 

[Fred Smith]

If you want your pace in mm:ss, which is most common with runners, change Gary's
formula to:

=a2/b2, and format the result to a time of mm:ss

 

[romelsb]

Tony....your pace is relative to your exhausted stress....not by direct
proportion of a sample pace....sometimes we forget to distinguish the factors
between things and human....