Pace chart calculation help

[silverhawk]

I enjoy running, and I help my coworkers with their running goals. Many of them are required to run 1.5 miles for an annual fitness test (6 laps on a quarter mile track), and I'd previously developed a chart that would tell them what their lap pace on a track needed to be in order to pass said test. I've even added different categories hased on how certain runners track their pace (mile, quarter mile, tenth mile, speed). However, having recently moved I have discovered an indoor track that is used during bad weather. This indoor track requires them to run 26 laps + 102 extra feet for the same mile-and-a-half distance (the math comes out to 302 feet per lap), and several of them have found that they pace better off this one, based on a given random number (say 35 seconds per lap).

Since I'm new here and don't know how to simply attach a spreadsheet, here's an example of what I already have (labels, format, data, formulas):

1.5 mi pace	1 mi pace	0.25 mi pace	.010 mi pace	Speed
Text	Custom: m:ss.00	Custom: m:ss.00	Custom: m:ss.00	Number
12:00	=(((MID(A3, 1, 2) * 60) + MID(A3, 4, 2)) * (2 / 3)) / 86400	=B3 / 4	=B3 / 10	=3600 / (((MID(A3, 1, 2) * 60) + MID(A3, 4, 2)) * (2 / 3))
12:00	8:00.00	2:00.00	0:48.00	7.500
12:05	8:03.33	2:00.83	0:48.33	7.448
12:10	8:06.67	2:01.67	0:48.67	7.397

How can I calculate and format the time of the 26-and-a-bit-lap track?

 

[cerfani]

one lap like you said is 302 feet so 302/5280 = 0.0571969696969...

so calculate the pace for that...

here is your header for this 5th column...

=302/5280&" mi pace"

And the pace needed based on the 1 mi pace

=302/5280*B2

Also your 0.010 mi pace calculation is wrong... you are actually calculating a 0.10 mi pace if you are dividing the 1 mi pace by 10

 

[silverhawk]

Thanks. I did a little tweaking to get more exact measurements (just shy of 302 ft; my half-marathon runner is a bit of a perfectionist), and it worked splendidly.
Also, good call on the .010. I meant to say 0.10, but fat-fingered it when typing.