Hi,
I am stuck with a situation with Excel formula, I need to calculate how many days in a row someone has worked, it should not be more than 16 days in a row (inclusive of both day and night shift), otherwise highlight this, and also how many consecutive night shifts someone has worked, it should not be more than 7 nights in a row, otherwise highlight this.
Help on this is greatly appreciated.
Thank you.