converting times from 3 miles to 5k

Add 30 secs to overall time if under 16:00

Add 35 secs to overall time if under 18:00

Add 40 secs to overall time if under 20:00

Works out plus or minus 2 secs usually, use it in HS level coaching all the time.

That's pretty close to what I've been doing. I was looking for a little more precision but I guess if a kids not going much under 17 for a 3 mile it doesn't matter much anyway.

Try using a spreadsheet program such a Lotus123, Microsoft Excel, Google Docs or OpenOffice Calc.

This would be how you would do it in Excel 2007

You enter values in Columns A-C

Col A = Runner's name

Col B = 3mi Minutes (e.g. 16:20 => 16)

Col C = 3mi Seconde (e.g. 16:20 => 20)

Enter the following formulas in in D-G (starting at Row 1 paste the stuff inbetween the quotation marks)

Col D = 3mi time in seconds = "=B1*60+C1"

Col E = 5k time in seconds = "=D1*1.03562"

Col F = 5k Minutes = "=FLOOR(E1/60,1)"

Col G = 5k Seconds = "=FLOOR(MOD(E1,60),1)"

Track and Field used to have a conversion table for distances. I'm not sure but I think they used 3.6% for the 3M/5,000. I know it was x1.08 for the 1,500/mile. That way it would be applicable to all times, regardless of pace.

Try it out 13:00 3mile is 780 seconds x 3.6% is 28.08, so 13:28 for 5k. Seems about right.

I think they got that by comparing the records for the two events over time and averaging the difference.

EvilComputerGeek wrote:

Try using a spreadsheet program such a Lotus123, Microsoft Excel, Google Docs or OpenOffice Calc.

This would be how you would do it in Excel 2007

You enter values in Columns A-C

Col A = Runner's name

Col B = 3mi Minutes (e.g. 16:20 => 16)

Col C = 3mi Seconde (e.g. 16:20 => 20)

Enter the following formulas in in D-G (starting at Row 1 paste the stuff inbetween the quotation marks)

Col D = 3mi time in seconds = "=B1*60+C1"

Col E = 5k time in seconds = "=D1*1.03562"

Col F = 5k Minutes = "=FLOOR(E1/60,1)"

Col G = 5k Seconds = "=FLOOR(MOD(E1,60),1)"

dude - why not just type 0:16:20 in cell and let excel do the time calcs for you?

dude - why not just type 0:16:20 in cell and let excel do the time calcs for you?

Excel time calcs like that only work with times if the time is 23:09 or less for 3mi. Of course nobody on lets run is that slow.

You could go to McMillan and do that.

http://www.mcmillanrunning.com/mcmillanrunningcalculator.htm

If you format the cell as custom-> m:ss

then you can do calculations for any time that you want, not just under 24.

At 16:00-flat the .11 miles would be ~34 seconds if you ran even pace. Of course there will be some fade when you run longer, but if you want to ignore that, use this:

3 mile time X (5000m/4828m) = 5k time

or

3 mile time X (3.11 mi/3.0 mi) = 5k time

the ratio is 1.0356 as was explained earlier. It is easy math. When people asked what you would use 6th grade algebra for ... well, here it is.

what are you talking about?

Multiply the 3M time (in seconds) by 1.038 to get an equivalent 5k time (in seconds). This accounts for the expected slowdown when running the slightly longer distance.

Examples:

14:00.00 (840 seconds) for 3m ~ 14:31.92 for 5k (871.92)

15:00.00 (900) 3M ~ 15:34.20 5k (934.20)

16:00.00 (960) 3M ~ 16:36.48 5k (996.48)

Looks like you still have to do the multiplying on all 30 performances, but at least this conversion will be accurate.

how did you get 13:28 from 28.08

Ok McMillan is rubbish on this. I just finished a "certified" course blown because of the ill-placement of a race marshal. A bunch of runners had GPS readings of 3.0 miles for a "certified 5k." I ran the thing expressly because it was certified. My time was 20:00. I am calling this a 20:40. According to McMillan it was a 20:53, which means I would have crawled the last 1/10th mile at a 9:00 mile pace. I was still running in the 6:30s in the last 400 meters of that race. Absurd to calculate that I would have bonked and jogged. I had plenty in the tank. McMillan is high.

Christopher White wrote:

Ok McMillan is rubbish on this. I just finished a "certified" course blown because of the ill-placement of a race marshal. A bunch of runners had GPS readings of 3.0 miles for a "certified 5k." I ran the thing expressly because it was certified. My time was 20:00. I am calling this a 20:40. According to McMillan it was a 20:53, which means I would have crawled the last 1/10th mile at a 9:00 mile pace. I was still running in the 6:30s in the last 400 meters of that race. Absurd to calculate that I would have bonked and jogged. I had plenty in the tank. McMillan is high.

Did you enter your 20:00 as 3 miles or 4800m?

Christopher White wrote:

Ok McMillan is rubbish on this. I just finished a "certified" course blown because of the ill-placement of a race marshal. A bunch of runners had GPS readings of 3.0 miles for a "certified 5k." I ran the thing expressly because it was certified. My time was 20:00. I am calling this a 20:40. According to McMillan it was a 20:53, which means I would have crawled the last 1/10th mile at a 9:00 mile pace. I was still running in the 6:30s in the last 400 meters of that race. Absurd to calculate that I would have bonked and jogged. I had plenty in the tank. McMillan is high.

Exactly how accurate does a hypothetical time have to be?

Even if a bunch of GPS readings indicated those machine covered 3.0 miles it does not make it a certified 3.0 course. Thinking that coming up with a formula to tell you your hypothetical time for a distance you did not run based on an estimation of the distance you did run would result in a precise and accurate time seems folly.

Call it 20;40 and if anyone gives you crap you tell them I said it's OK.

Mr White--running exactly 3.0 miles in exactly 20:00.00 would be the same level of excellence as running a 5k in 20:46.05 per Purdy (or 20:45.13 or 20:45.61 or 20:45.35 using commonly used calculators VO2Max, Cameron and Riegal resulting in an average of 20:45.54).

more info

http://run-down.com/statistics/calcs_explained.php

To the OPs question -- automated calculations here>

http://tools.runnerspace.com/gprofile.php?do=title&title_id=801&mgroup_id=45577

Advice to those who spend effort on calculating "what if times" remember a certified course has a Short Course Protection Factor so you should subtract the time that distance is worth to give you a truer picture of your real worth. Wind resistance, humidity, elevation, sun to shade ratio, congestion preventing you to run the optimum tangents, etc. all play to alter your true time so factor those in too.

With astute calculation you could turn a ho-hum 50 minute 10km into a stellar sub 30 race. I do it all the time.

I entered it as 3 miles @ 20:00.

Of course its not a big deal in large or even the small scheme of things, but nevertheless people run certified courses (and pay $40.00 to do so) to avoid all the doubt that goes with rinky-dink 5ks. I guess I got robbed out of my certified time; but my real point was that I've never covered the last .1 of a 5k in 53 seconds. I mean that's almost a 9 minute mile when I was running 6:35 for the .1 right before that. Something is wrong with the calculator. Does not compute.

Christopher White wrote:

Of course its not a big deal in large or even the teeny-tiny itsy-bitsey scheme of things, but nevertheless people run certified courses (and pay $40.00 to do so) to avoid all the doubt that goes with rinky-dink 5ks. I guess I got robbed out of my certified time; but my real point was that I've never covered the last .1 of a 5k in 53 seconds. I mean that's almost a 9 minute mile when I was running 6:35 for the .1 right before that. Something is wrong with the calculator. Does not compute.

At 2:53ish marathon pace you average 25/26 seconds per hundred yds so the extra 188yds 22.5 + 25 secs =48

. ..

you paid for a piece of ID, A certified time for 5KM, and like a scout merit badge or a US$ in has a value because it is a metric with a known standard 26 wiggwams styles mastered or 1.12 Loonies. Expenses to put on a toad race soar, TD charge more, scramble for sponsors, and use well meaning but undertrained volunteers who do not understand the job blah blah, business words yada yada you spend big bucks to get a certified time. Miss mark a course is a big mistake because of the ramifications but it's a small error in the sense that the guy was told to set the table and he put the salad fork in the dinner fork position.

It happens get over it or call the Better Business Bureau and tell them you want a law like the automobile Lemon Law. Same idea- promised a product they failed to deliver.

Trust me only a letsrun thread would get you any comment for saying I ran 20;40 for 5km without a searchable certified race result.