linking cells with scheduling workbook

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
External cell reference between two excel worksheets both in One Drive 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Employee Scheduling Worksheet 10
Payment calculation 1
Publisher is filling blank lines with data 2
Linking data from one worksheet to another using ookup functions 2
Summarizing multiple worksheet data 0

Top