Calculate average min:sec per mile for jogging spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I'm trying to calcualte average min:sec (time) per mile jogged. Having
trouble converting recorded time into a min:se format for calculating average
times per mile. For example converting cell A1 - 21:49 (21min:49sec) run
over a 2.25 mile distance (cell B2 ), into average time per mile run.

Thanks!!
 
Jerry,

If:-

A2= 00:21:49
B2= 2.25
C2= =A2/B2

and format c2 as "hh:mm:ss.0" you will get the result 00:09:41.8


i.e. 9 mins 41.8 secs per mile

regards,

JohnI
 
Assume you have
the times in col A (e.g.: 21:49, in [h]:mm format),
the distances (miles) in col B (e.g.: 2.25),
data from row2 down

Put in C2: =A2/B2
(Think formatting C2 into time would be automatic)

Copy down

If time in A2 is: 21:49, and
distance in B2 is: 2.25
C2 returns 9:41
 
Back
Top