0 votes

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, 2023 in Others 7,250 views

## 1 answer to this question.

0 votes

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:

answered Jan 9, 2023 by
• 63,720 points

0 votes
1 answer

## 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

0 votes
2 answers

## How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

0 votes
0 answers

## MS Excel - SumProduct formula with Loop

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

0 votes
1 answer

## Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

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

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

0 votes
0 answers

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

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

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

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

0 votes
1 answer

## Excel formula gives error when write using Apache-poi library in Java

I tested some sample code. The cell ...READ MORE

0 votes
1 answer

## Why percentage calculation in excel gives me incorrect numbers

Please be specific with your query. Do ...READ MORE