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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Average formula 4
Nested Array Formula to Determine Average cost Per Mile in 100 mileincrements 1
help w indirect and index,match 3
Longtitude and Latitude Question 4
Average minutes per mile 7
Formula Help 0
Combining two sheets of data into one and sorting by value - using macros 5

Top