Calculate average min:sec per mile for jogging spreadsheet

[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!!

 

[JohnI in Brisbane]

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

 

[Max]

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

 

[Guest]

thanks for the tip! it's going to help in my marathon training

 

[Max]

Pleasure' Jerry !
Thanks for the feedback