My wife and I have been running and when we get home, I put our times and distances in Excel. It helps track our training efforts each, as a runner who is tracking our training pace.
Up until recently I was doing it in an ugly and complicated fashion and was showing decimals in minutes. I decided to sort this out and not only simplify the process, but show the proper min:sec results for our efforts.
So here’s what I figured out:
Let’s say you use column B2 for your time & C2 for your distance, I’d use column D2 for your result and just for a hoot, I added column E2 to show my MPH for the total run.
The trick is the format of cells B2 & D2. If you right-click on each cell and choose the following:
Format Cells;
Custom;
Choose “h:mm:ss” for cell B2, & “mm:ss.0″ for cell D2. This will convert the cell so it will show your time in minutes per mile, under the clock scale rather than an integer number.
The Equation in cell D2 is “=B2/C2″. Cell D2 will then show your minutes per mile.
Bonus: In cell E2, I put in the equation =C2/(B2*24). I also format the cell as a number with 2 decimal places.
Snag: The only snag is that you need to be literate in how you enter your time. For your run times, you will need to enter 0:25:30 (25 minutes, 30 seconds) for your time.
Enjoy!
{ 1 comment… read it below or add one }
Thanks for the information about minutes per mile in Excel; just what I needed to keep my running log.
Larry