Marathon Pace Chart

  • Thread starter Thread starter CM
  • Start date Start date
C

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,

CM
 
Assume you have 3:45:00 in A1, in B1 put 1 and in B2 put 2, select both
cells and copy down 42 rows. In C1 put

=A1/42.195

format as hh:mm:ss

now in C2 put

=$C$1+C1

copy down to C42

now to get the time for the last 195 meters use

=A1-C42

gives 00:01:05 for the finish..

I one did it in 3:05, the last quarter was hell and I was bedridden for 2
days after,
I kept going by pretending that every lamp post was a Kenyan runner and that
it was
the Olympic finals <g>
 
Hi

Put you km stages in one column, from 1 to 42.2 (I guess!).
Alongside 1 put 0:5:30, formatted as h:mm:ss. Alongside 2 (say B3) put
=B2/A2*A3 and fill down. Then you can use Goal Seek on the cell alongside
42.2 to input your finish time and find out the split times by changing cell
B2

Andy.
 
Back
Top