Forum Discussion
Formula Miscalculation
sample employee 1 sample employee 2 sample employee 3 We use excel for our employee timesheets and have used the same template for YEARS. Each employee has their own workbook with sheets for each pay period and time worked accordingly. Last week I was running payroll and noticed that for several of the employees the "lunch" time is no longer being counted out. We have again been using this same template and formula for quite a while with no issues and it is only certain cells while the others calculate correctly. I contacted Microsoft support only to be told "customer support can only do so much and I need someone with advanced excel knowledge". Is there anyone on here who may be able to help me find the root of the error so I can correct it?
8 Replies
CV2023 Well, begin by sharing the template (via Onedrive or similar) so that we can have a look at it. Enter some fake data in it that demonstrates the problem.
- Ok I have posted the samples
CV2023 Have a look at the attached file where I completely changed the formula in the Blank sheet. The existing one was a monster. See if the revised template works better.
