Hello.
I am new here, and not so experienced in Excel, so I am not sure if this is possible, so I hope someone will be able to help me.
I am creating a work schedule in Excel for employees at company where I work, and I would like to do this, if possible. Work schedule is divided in colums by date of the month and in rows by the name of the employee. We have 13 different shifts of which some are valid only on working days and others only on weekends. For example: shift 1 is from 8am to 4pm valid only mon - fri, shift 2 from 10pm till 9 am next day and valid only from fri - sun, and so on. I would like for Excel to highlight for me each date in column if I miss some shift that is mandatory for that day. Foe example, if on monday we need shifts 1, 2, 3, 4 and 5, is it possible for Excel to highlight that column or specific cell at the bottom of the column if one or more of the shifts are missing? And maybe even write what shift(s) is missing?
And second question - can Excel sum working hours for each employee? Every employee will have different shift thru month. So many different shift will need to be calculated. And I need to write shift numbers, so Excel needs to read shift numbers from rows, than recognize that shift 1 is 8 working hrs, shift 2 is 11 working hrs, and then sum that and display result in some cell.
If you know this can be done please let me know with what formula or macro? If you have some specific advice it would be even better.
Thank you in advance.