J JBT Oct 15, 2008 #1 I'm trying to come up with the avg/mile for race times. Is there a formula or setting that needs to be used?
I'm trying to come up with the avg/mile for race times. Is there a formula or setting that needs to be used?
P Peo Sjoblom Oct 15, 2008 #2 Assume you have 10 miles in A1 and 00:35:25 (35 minutes and 25 seconds) in B1 =B1/A to get the average time per mile = -- Regards, Peo Sjoblom
Assume you have 10 miles in A1 and 00:35:25 (35 minutes and 25 seconds) in B1 =B1/A to get the average time per mile = -- Regards, Peo Sjoblom
S Sean Timmons Oct 15, 2008 #3 so.. do we assume you have, say, distance travelled and time travelled? Let's say x is your distance and y is your time y/x = time to travel your distance. If x is in feet, (y/x)*5280 gives time per mile. Otherwise, could you give further details?
so.. do we assume you have, say, distance travelled and time travelled? Let's say x is your distance and y is your time y/x = time to travel your distance. If x is in feet, (y/x)*5280 gives time per mile. Otherwise, could you give further details?
