William,

In cell B1, enter the track size, in decimal miles.
In cell B2, enter the distance that you want to run.
In cell B3, enter the pace in 0:minutes:seconds that you want to run: 0:8:30 to enter 8 minutes and
30 seconds per mile.

For just lap times, in cell B4, enter this
=IF(ROW(B1)<=$B$2/$B$1,"Lap " & ROW(B1) & ": " & TEXT($B$1*ROW(B1)*$B$3,"mm:ss"),"")

Format B3 and B4 for m:ss, and then copy B4 down the row as far as you want.

Or, put this in A4:
=IF(ROW(B1)<=$B$2/$B$1,"Lap " & ROW(B1) & ": ","")
And this in B4
=IF(ROW(A1)<=$B$2/$B$1,$B$1*ROW(A1)*$B$3,"")

to split the times out so that you can do other math on them.

If you want the times at the 1/4, 1/2 and 3/4 marks around the laps, then use this in A4 (note that
the formula will probably wrap, so take out any line returns):

=IF((ROW(A1)-1 + COLUMN(A1)/4)<=$B$2/$B$1,"Lap " & ROW(A1) &": " & COLUMN(A1) & "/4: " &
TEXT($B$1*$B$3*(4*(ROW(A1)-1)+COLUMN(A1))/4,"mm:ss"),"")

and copy to B4:D4, then copy A4:D4 down for as many rows as you need.

HTH,
Bernie
MS Excel MVP


<William Dalton wrote in message ...
I am trying to apply what you have for an answer but am failing miserably! My ultimate goal is to
be able to provide 1/4, 1/2, 3/4 and Lap pace times around an unconventional track. To be able to
enter my desired completion time and the desired split times fill in. There would be 15 quarters,
not quite a complete 4th lap.