Race times
 

How do I calculate minutes per mile, minutes per Kilometer, etc in Excel?

Minutes per mile.........

=((StopTime-StartTime)*1440)/miles


Vaya con dios,
Chuck, CABGx3


"Tx Runner" <Tx wrote in message
...
How do I calculate minutes per mile, minutes per Kilometer, etc in Excel?

Either I did not enter the calculation correctly or asked the question wrong.
Examples of what I want to figu
(Cell A1) Distance: 3200 meters or 3.2 kilometers
(B1) Time: 13 minutes, 02 seconds
(C1) Pace: I want to calculate my pace per mile and my pace per 400 meters

(Cell A2) Distance: 2 Miles
(B2) Time: 6 minutes, 41 seconds
(C2) Pace: I want to calculate my pace per mile and my pace per 400 meters


"CLR" wrote:

Minutes per mile.........

=((StopTime-StartTime)*1440)/miles


Vaya con dios,
Chuck, CABGx3


"Tx Runner" <Tx wrote in message
...
How do I calculate minutes per mile, minutes per Kilometer, etc in Excel?

This might help with the mile pace, but you will have to do the 400m on your
own. This a formula from Thinman's running log, avail on his website.
=IF(D30,E3/D3,"")
http://thinnmann.com

Jim Harris

"Tx Runner" wrote:

Either I did not enter the calculation correctly or asked the question wrong.
Examples of what I want to figu
(Cell A1) Distance: 3200 meters or 3.2 kilometers
(B1) Time: 13 minutes, 02 seconds
(C1) Pace: I want to calculate my pace per mile and my pace per 400 meters

(Cell A2) Distance: 2 Miles
(B2) Time: 6 minutes, 41 seconds
(C2) Pace: I want to calculate my pace per mile and my pace per 400 meters


"CLR" wrote:

Minutes per mile.........

=((StopTime-StartTime)*1440)/miles


Vaya con dios,
Chuck, CABGx3


"Tx Runner" <Tx wrote in message
...
How do I calculate minutes per mile, minutes per Kilometer, etc in Excel?

Tx Runner wrote:
Either I did not enter the calculation correctly or asked the
question wrong.
Examples of what I want to figu
(Cell A1) Distance: 3200 meters or 3.2 kilometers
(B1) Time: 13 minutes, 02 seconds
(C1) Pace: I want to calculate my pace per mile and my pace per 400
meters

(Cell A2) Distance: 2 Miles
(B2) Time: 6 minutes, 41 seconds
(C2) Pace: I want to calculate my pace per mile and my pace per 400
meters


"CLR" wrote:

Minutes per mile.........

=((StopTime-StartTime)*1440)/miles


Vaya con dios,
Chuck, CABGx3


"Tx Runner" <Tx wrote in message
...
How do I calculate minutes per mile, minutes per Kilometer, etc
in Excel?


Tx Runner, try this formula
(A1) 3.20 distance
(B1) 0:13:02 time
(C1) =B1/A1 minutes per kilometre
(D1) =C1/10*4 time per 400 metres

hope this helps
Regards
Ditchy, Ballarat Australia