View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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?