Hi,
I have a master schedule which lists the start/end dates for each employee's task, along with an accompanying weekly gantt snapshot to the right. I'm trying to find a way to reflect their vacation which exists on another tab on the schedule's gantt chart, but am having a hard time figuring out the best way to do this.
For example, if someone is booked for the full week, it will reflect as a "1" in the gantt chart. If someone is booked a full week, but has 1 day off as listed in the other tab, it would show as 0.8 in the gantt chart.
Sample spreadsheet is attached. Any help would be greatly appreciated!!!
Thank you!!
Bookmarks