Excel's basic pace calculator is giving me problems.
Time/distance is used to calculate pace. So, the format for the time in A2 is (hh:mm). Distance is measured by B2, time in minutes is measured by C2, and pace is measured by D2 with =C2/B2.
All is well thus far. I get a pace of 6:00/km if I enter a time of 00:30 and a distance of 5 km, which is what I anticipated. If I use a greater time and distance, such as 2:59 and 27.42, however, I obtain a pace of 6:53 when it should be 06:31. (if I use an online pace calculator to check my results).
I think I'm converting the minutes of the pace to decimals instead of seconds when I calculate them. Additionally, the pace in the above image should be 6:17.99 and not 6:30.