HI
Sorry about the spelling am dislexic
I need to get some vba that will show me which shifts overlap
as you can see on line one there is a overlpap btween the start time of one shift and the endtime of the next
Date Type Start End Break Shift date Start Time End Time Shift type ?
03-Nov-12 L 12:00:00 20:00:00 30 03/11/2012 07:30:00 12:30:00 Early Shift OverLap
17-Nov-12 E 07:30:00 15:30:00 30 17/11/2012 15:30:00 20:00:00 Late Shift
21-Nov-12 N 19:30:00 07:45:00 60 21/11/2012 07:30:00 20:00:00 Day Shift overlap
26-Nov-12 E 07:30:00 15:30:00 30 26/11/2012 15:00:00 20:00:00 Late Shift OverLap
any help would be great
thanks
Bookmarks