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.
Excel is not adding correctly
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
2 answers
Sort by: Most helpful
-
-
Jiajing Hua-MFST 7,705 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.