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? If so, how?

I went to an online website that will calculate my pace for me. Running for 4 miles with a total time of 45 min and 29 seconds gives me a pace of 11:22. If I simply divide 45:29 by 4 miles, I get a pace of 11:32. There are 60 minutes in an hour and 100 parts in a whole. You can't compare the two and that is where the confusion comes in.

Thanks for any help!