M
MattSwift
I have an Excel workbook for scheduling employees in several departments.
Each department has their own sheet and their scheduled days/times are linked
to a comprehensive sheet so all employees and their schedule are shown on one
sheet. The comprehensive sheet is printed and posted to everyone.
The problem I am having is that if they have a day off and the cells for the
starting and ending time is blank on the ind. department sheet, the cells
display 12:00 AM on the comprehensive sheet. How do I program so that
whenever an employee is not scheduled, that day is blank for their starting
and ending time on the comprehensive sheet?
Each department has their own sheet and their scheduled days/times are linked
to a comprehensive sheet so all employees and their schedule are shown on one
sheet. The comprehensive sheet is printed and posted to everyone.
The problem I am having is that if they have a day off and the cells for the
starting and ending time is blank on the ind. department sheet, the cells
display 12:00 AM on the comprehensive sheet. How do I program so that
whenever an employee is not scheduled, that day is blank for their starting
and ending time on the comprehensive sheet?