ExcelBanter - stopwatch average per mile

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - stopwatch average per mile (https://www.excelbanter.com/excel-worksheet-functions/206524-stopwatch-average-per-mile.html)

jbt

stopwatch average per mile

I'm trying to come up with the avg/mile for race times. Is there a formula or
setting that needs to be used?

Peo Sjoblom[_2_]

stopwatch average per mile

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

"JBT" wrote in message
...
I'm trying to come up with the avg/mile for race times. Is there a formula
or
setting that needs to be used?

Sean Timmons

stopwatch average per mile

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?

"JBT" wrote:

I'm trying to come up with the avg/mile for race times. Is there a formula or
setting that needs to be used?

All times are GMT +1. The time now is 01:51 AM.