I've been asked to find a way in excel to find out when an employee (each one has a unique employee id) has an overlap in their training times (2/21/2018 2:45 PM 2/21/2018 2:53 PM) << shown in two separate columns and if it overlaps with an absence code so their training time can be rescheduled. I was thinking pasting the absence stuff in one tab and then the training times in the second tab and then have the results in a third tab which would show the cross-reference results. Any help would be great.
Bookmarks