Excel pace formula gives incorrect answers

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.

basic pace formula

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 by Kithuzzz
• 38,010 points
5,578 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:

enter image description here

answered Jan 9, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
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

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
731 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,670 points
254 views
0 votes
1 answer

Excel - IF Formula with a FIND

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

answered Sep 27, 2022 in Others by narikkadan
• 63,420 points
520 views
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

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,237 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,425 views
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

Feb 17, 2022 in Others by Edureka
• 13,670 points
698 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,331 views
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

answered Nov 5, 2022 in Others by narikkadan
• 63,420 points
1,331 views
0 votes
1 answer

Why percentage calculation in excel gives me incorrect numbers

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

answered Dec 11, 2022 in Others by narikkadan
• 63,420 points
544 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP