I'm trying to create a hour based gantt for a week production scheduling using the conditional formating.
The production can work 24h/day, divided into shifts of 8 hours. (the shifts are fixed but the production could be stoped in some shifs).
I'm trying to use a check box to select the working/non working Shifs, but I cant find a way to exclude the non working Time from the total time avaiable.
I've tryed the NETWORKDAYS function and include the non working shifts in the Holydays but it doesn't work in a hour based time.
Any help would be much appreciated.
Thanks
EXcel file: Download Gantt production scheduling.xlsx
The production can work 24h/day, divided into shifts of 8 hours. (the shifts are fixed but the production could be stoped in some shifs).
I'm trying to use a check box to select the working/non working Shifs, but I cant find a way to exclude the non working Time from the total time avaiable.
I've tryed the NETWORKDAYS function and include the non working shifts in the Holydays but it doesn't work in a hour based time.
Any help would be much appreciated.
Thanks
EXcel file: Download Gantt production scheduling.xlsx
