Excel is not adding correctly

Cindy G 0 Reputation points
2024-03-06T17:31:34.7033333+00:00

I keep track of employee hours in excel, and each employee has their own spreadsheet. Each one is identical as far as formulas and formatting go, and the only difference is the name field and time values entered. At the moment, I have one employee's spreadsheet that is not correctly summing their time. It's only off by .01 hour, but needs to be correct. I can enter the same numbers in another employee's spreadsheet and they add correctly. Also, this doesn't happen every time so I'm really at a loss. I am also not an expert in excel by any means. I can provide more information if anyone could please help me out. Thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,430 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Cindy G 0 Reputation points
    2024-03-06T17:42:30.9666667+00:00

    Edit to add: Each day has it's own row, where time-in, time-out and lunch duration are entered. The last cell of the row is a calculation of hours worked. It's these cells at the end that I'm adding together to get the total amount of time they worked. Just to see, I entered the totals in another column that isn't used, and the sum is correct. It would seem that something is getting lost with the formulas involved, but each employee's formulas are identical so I can't figure out where the breakdown is.

    0 comments No comments

  2. Jiajing Hua-MFST 4,360 Reputation points Microsoft Vendor
    2024-03-07T01:04:39.6266667+00:00

    Hi @Cindy G

    As I cannot see your file, I'll offer some ideas.

    It is recommended to check the range of cells for the additive data.

    Please also check the number of digits for the decimal point.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.