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