Race times

C

CLR

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

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


Vaya con dios,
Chuck, CABGx3
 
T

Tx Runner

Either I did not enter the calculation correctly or asked the question wrong.
Examples of what I want to figure:
(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
 
J

Jim Harris

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(D3>0,E3/D3,"")
http://thinnmann.com

Jim Harris
 
D

ditchy

Tx said:
Either I did not enter the calculation correctly or asked the question wrong.
Examples of what I want to figure:
(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
Click to expand...
(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
 
Top