Please refer to attached workbook where I need some formula assistance (not my workbook, assisting someone else)
I have given two options, one without helpers on the "Roster" sheet, or one with helpers on the "Count" sheet.
I need three counts
1. Number of one day non work breaks
2. Number of two consecutive day non work breaks
3. Number of three consecutive day non work breaks
Roster sheet no helpers
Require formula in E46:E48 that can be filled across
Count sheet with helpers
Require formula in AD1:AF1 that can be filled down
I don't mind either way you do it.