Hi,
I'm new here, so if this question is posted elsewhere, sorry.
I have 92 employees that I need to keep track of whether they are working too many days in a row.
I have a spreadsheet with everyone's names and nine days worth of data. In column a is everyone's name. In columns c3:k3, it tells me how many hours each employee is working each day. I don't need the total hours. I need a formula to tell me if they have too many days in row or whether they are good. They cannot work more than six days in a row.
I've tried subtotal and filters and countif, but I can't get it.
Here is what I have been experimenting with, but it's doesn't take into account how many days in a row: =IF(MAX($C3:$K3)>6,"Too Many Days","Good to Go")
It only works if the data is presented like this:
4.5 8 4 4.5 8 4.5 8
If there are blanks (i.e. a day off), it still returns too many days even if they aren't working more than six days in a row.
I would like a column (column b preferably) to return either too many days OR good to go if they are scheduled more than six days in a row.
If I had to rate my excel knowledge, it'd be a 5/6 on a scale of 1-10, so I am really stuck.
Please help if you can!
Bookmarks