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.

Calculating running pace in Microsoft Excel is quite simple. You can use the formula to calculate your running pace. Here's how you can set it up in your spreadsheet:

1. Create a new column for your running pace. You can label this column "Pace" or "Mile Pace."
2. In the first cell of the Pace column, enter the formula
   Code:

   "=time(0,0,Distance/Time)"

   where "Distance" is the distance you ran (in miles) and "Time" is the time it took you to run that distance (in minutes).
3. Press Enter to calculate the running pace for that row.
4. Copy the formula down the entire column to automatically calculate the running pace for each row.
5. You can format the cells in the Pace column to display the time in a more readable format. Right-click on the cells, select "Format Cells," and choose "Custom." In the "Type" field, enter "mm:ss" to display the time in minutes and seconds.

That's it! Now, every time you enter the distance and time for a run, the running pace will be automatically calculated in the Pace column. This will save you time and make it easier to track your progress over time.

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

TonyM wrote:
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.

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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"TonyM" wrote:

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.

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

--
Regards,
Fred


"Gary L Brown" wrote in message
...
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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"TonyM" wrote:

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.

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....

"Fred Smith" wrote:

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

--
Regards,
Fred


"Gary L Brown" wrote in message
...
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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"TonyM" wrote:

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.