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.

Jan 9 in Others 3,890 views

## 1 answer to this question.

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: • 63,220 points

## INDEX MATCH formula in Excel returning incorrect results in some cells and correct results in others

Step through the formula that produces the ...READ MORE

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE