Overlapping EZM.zip (1010.3 KB)
Hello,
I was hoping that someone could help me with creating an EZM that would identify overlapping timecard shifts between two systems.
Our company has one website where employees enter their timecards, and another website that I import that time into for processing payroll.
I’ve attached a work-in-progress EZM that I created to check for overlaps. It imports two spreadsheets:
- Timecard_Data_Detailed_Report - This is the timecard data entered by employees.
- Time Management - This is data from the website that I import timesheet into from spreadsheet #1.
From the Timecard_Data_Detailed_Report, I want to do two overlapping checks:
- Overlaps with Self- Identify if an employee has overlapping time with another shift from the same report.
- Overlaps with Time Management- identify if an employee has overlapping time with a shift that’s already in Time Management.
I don’t need to know if one employee’s shift overlaps with another employee’s shift, only if an employee has overlapping time with themselves in either system. The Employee number column is the column to use for identifying the employee. There is also a Project Code column to identify the type of work being done and a client ID column to identify who the work was done for.
In the attached EZM, I’ve formatted the two reports so that the dates and times match in the Formatting tab. I have a blank Overlapping tab where I would do these overlapping checks, but I’m not sure where to start.
