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...
if the shift ended at 11:30 on 5/23/2021 how can the next shift be starting at 11:00 on 5/23/2021?
- It's how they're scheduled, so in that instance, the employee picked two shifts that overlapped to get more hours, which is half the issue in tracking things.
I ended up reworking the report with our IT Team to get what we needed, which, although it's very clunky, more or less resolved the issue.
