Forum Discussion
Logic formula direction - complex equation based off COUNTIFS
Hello - I'm looking for some direction on how to build a logic formula in the attached file that will find the specific shifts that went over the scheduled time. The HR system at my company has a gli...
I am not sure I understand the logic even allowing for the overlapping shift. What I have done is illustrate a formula that accumulates the hours worked within the day, in the hope that it might be something you could use. Be careful if your table has 1000s of rows because the formula becomes computationally expensive.
Thank you - I may actually use that formula in the future. I ended up working with our IT Team to rework the report, and it has worked so far.