How do you write the formula to calculate pace per mile (running) in Excel?

H

Heather B

New member
I have an Excel spreadsheet to keep track of my training for a race I am going to do. I would love to enter a formula that will calculate my pace per mile. I already have a cell where I enter my distance I ran, a cell where I enter the time it took me to run that distance, and I have a cell to calculate the pace per mile. It is not as simple as dividing the distance by the time taken to run the distance, there is more to it than that, I just don't know what it is :-)

Let's say in cell D2 is my distance of 4 miles, and in cell E2 is my total time of 45 minutes and 29 seconds, what formula would I enter in F2 to calculate my pace per mile? Do I need to format any of the cells?

Thanks for any help!
 
Back
Top