Excel pace formula gives incorrect answers

Question

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.

Answer 1

6.3 is correct answer just not in your desired format.

If you have your A column formatted in "hh:mm". Just simply divide A/B and use correct formatting. Either hh:mm:ss.000 or mm:ss.000 . Result: