Good day,
I am busy building an automated shift system whereby I will be able to generate my own shift system by only indicating the master shift pattern and then I want it for 6 employees with conditional formatting indicated by a separate column.
Thus, if the shift pattern is DDDDNNOOOOODDDNNNOOOOO, I would like each employee to start at a different shift,ex. one at D, one at N and one at O, and then the cells must automatically continue with the pattern? Also, there must be atleast two O per day.
Thanks in advance.
I am busy building an automated shift system whereby I will be able to generate my own shift system by only indicating the master shift pattern and then I want it for 6 employees with conditional formatting indicated by a separate column.
Thus, if the shift pattern is DDDDNNOOOOODDDNNNOOOOO, I would like each employee to start at a different shift,ex. one at D, one at N and one at O, and then the cells must automatically continue with the pattern? Also, there must be atleast two O per day.
Thanks in advance.