stopwatch average per mile

J

JBT

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

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

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?
 
Top