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
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
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
