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?