Empolyees are scheduled to work with their lunch breaks. To make sure there is at least one person to cover, I like to visually see the bars which represent their work hours so that I can schedule lunch breaks properly.
For example:
Person A is scheduled from 8:00 to 12:00 lunch break from 12:00 to 1:00 and back to work from 1:00 to 5:00
Person B is scheduled from 8:00 to 1:00 lunch break from 1:00 to 2:00 and back to work from 2:00 to 5:00
Please help me with VBA code to automatically represent these work hours by highlighting in different columns?
For example:
Person A is scheduled from 8:00 to 12:00 lunch break from 12:00 to 1:00 and back to work from 1:00 to 5:00
Person B is scheduled from 8:00 to 1:00 lunch break from 1:00 to 2:00 and back to work from 2:00 to 5:00
Please help me with VBA code to automatically represent these work hours by highlighting in different columns?