Speed Zone Tables in km instead of miles - Eric Orton Running Academy 2019-12-14T07:13:42Z http://www.runningwitheric.com/forum/topics/speed-zone-tables-in-km-instead-of-miles?feed=yes&xn_auth=no https://www.runnersworld.com/… tag:www.runningwitheric.com,2019-05-08:3202872:Comment:176402 2019-05-08T22:48:48.520Z Ben Lynch http://www.runningwitheric.com/profile/BenLynch <p><a href="https://www.runnersworld.com/training/a20801331/pace-converter/" rel="nofollow">https://www.runnersworld.com/training/a20801331/pace-converter/</a></p> <p>This is a good resource to cross check the zones. Excel is a good tool for conversions.</p> <p></p> <p>I had a play in excel to do the conversion and found success with simply dividing by 1.609344 (the mile to km factor). To do this you need to input the pace as a time i.e 6:30.…</p> <p><a rel="nofollow" href="https://www.runnersworld.com/training/a20801331/pace-converter/">https://www.runnersworld.com/training/a20801331/pace-converter/</a></p> <p>This is a good resource to cross check the zones. Excel is a good tool for conversions.</p> <p></p> <p>I had a play in excel to do the conversion and found success with simply dividing by 1.609344 (the mile to km factor). To do this you need to input the pace as a time i.e 6:30.</p> <table border="0" cellspacing="0" width="64" style="border-collapse: collapse; width: 40px;"> <tbody><tr style="height: 15.0pt;"><td height="20" align="right" width="64" style="height: 15.0pt; width: 48pt;"></td> </tr> </tbody> </table> OK, So I think this is the fo… tag:www.runningwitheric.com,2018-07-20:3202872:Comment:172494 2018-07-20T11:28:39.155Z Jeff Jorgensen http://www.runningwitheric.com/profile/JeffJorgensen <p>OK, So I think this is the fomula to convert from minutes per mile to minutes per km.  Just substitute the "P4" for the cell you want to convert.</p> <p>=(TRUNC((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60))+(ROUND((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60,2)-TRUNC(ROUND((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60,2)))*60/100</p> <p></p> <p>Seems to work so far.</p> <p></p> <p>Jeff</p> <p>OK, So I think this is the fomula to convert from minutes per mile to minutes per km.  Just substitute the "P4" for the cell you want to convert.</p> <p>=(TRUNC((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60))+(ROUND((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60,2)-TRUNC(ROUND((((TRUNC(P4)*60)+((P4-TRUNC(P4))*100))/1.60932)/60,2)))*60/100</p> <p></p> <p>Seems to work so far.</p> <p></p> <p>Jeff</p> OK,  So I did my mile test ye… tag:www.runningwitheric.com,2018-07-20:3202872:Comment:172697 2018-07-20T10:34:56.730Z Jeff Jorgensen http://www.runningwitheric.com/profile/JeffJorgensen <p>OK, </p> <p>So I did my mile test yesterday and have been trying to work out how to convert my Mile time (1.60932 Km) to Km's.  First I thought that you could just divide the time by 1.6 and this would give me a minutes / km time.  Nup that didn't work.  So I worked out that I had to convert the time to seconds, then divide by 1.60932, then divide that number by 60. Then any decimal point after that needed to be converted to seconds rather than the faction of a minute that it…</p> <p>OK, </p> <p>So I did my mile test yesterday and have been trying to work out how to convert my Mile time (1.60932 Km) to Km's.  First I thought that you could just divide the time by 1.6 and this would give me a minutes / km time.  Nup that didn't work.  So I worked out that I had to convert the time to seconds, then divide by 1.60932, then divide that number by 60. Then any decimal point after that needed to be converted to seconds rather than the faction of a minute that it was.</p> <p>TI'll post the formula when I refine it a bit more.....</p> <p></p>