Hello everyone,
I'm trying to link somehow 2 seperate cells. In one says "Vacation" and in the other "0" value for the amount of hours it would be scheduled for that day.
I have a chart where I can select from a scroll the time of the day the shifts would start and end for all 7 days for each of my employees that is linked to another chart with the listing of time of incoments of 15 min. Top 2 cells are "OFF" and "Vacation". I have another chart where it adds up how many hours that person is scheduled for that given day and then the first chart has a column where it adds them all up per person. My problem is when I select either "OFF" or "VACATION" it does display them as I want them but in the total hours areas I get "######"
What do I have to do to Still have it displayed what I need it to and count those cells value as 0?
I'm trying to link somehow 2 seperate cells. In one says "Vacation" and in the other "0" value for the amount of hours it would be scheduled for that day.
I have a chart where I can select from a scroll the time of the day the shifts would start and end for all 7 days for each of my employees that is linked to another chart with the listing of time of incoments of 15 min. Top 2 cells are "OFF" and "Vacation". I have another chart where it adds up how many hours that person is scheduled for that given day and then the first chart has a column where it adds them all up per person. My problem is when I select either "OFF" or "VACATION" it does display them as I want them but in the total hours areas I get "######"
What do I have to do to Still have it displayed what I need it to and count those cells value as 0?
