Marathon Pace Table

[CM]

Hi All,

Any help with this one would be really appreciated.

I want to create a worksheet that will calculate split times, for each km,
for a marathon run based on a pre-determined finish time.

eg. Finish time 3:45:00

1km 0:5:30
2km 0:11:00
3km 0:16:30
..
..
..
..
42.2 3:34:00

I'd also like to add the ability to add time to the 2nd half, from 21km to
the finish.

Thanks,

 

[Peter van Deelen]

Hi CM,

I think you first problem can be solved like this:

In the cells A1 thru A43 you have the numbers 1, 2, 3, etc., 42, 42.195.

Set the format of column B to Time(UU:MM:SS).

Insert your pre-determined finish time in cell B43.

In cell B1 enter the formula: =B$43*A1/A$43

Copy this formula to cells B2 thru B42.



I don't exactly understand what your second problem implies.



Have fun!



Peter

 

[Peter van Deelen]

Sorry, the format of columb B should be Time(HH:MM:SS).

Slip of the keyboard (uur is Dutch for hour).

Peter