Equation That Makes Sure Every Employee Has 80 Hours Per Two Weeks

I am trying to come up with an equation that checks to make sure every employee has 80 hours per two weeks. It is tricky because there are many different possible shifts with lengths of either 8, 9, or 10 hours. I don't really have any idea how to go about this, so any help would be greatly appreciated.

I have attached an example schedule. All shifts that have no numbers after them are eight hour shifts. The ones with a -9 are nine hour shifts, and the -10 are ten hour shifts.

Thanks for your help!

TEST_SCHED.xlsx

Alright, so I have an idea, but I am not sure if there is a way to accomplish this. Starting with this equation:

=IF(OR(ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"I","A","X","R","K","E","AL","FFSL","ADM*"})))=10),"80 Hours","Error")

I would like to embed an AND statement within the same IF statement, if that is at all possible. For instance, the equation above checks all the 8 hours shifts. If there are 10 of them then they are schedule to work 80 hours. I next need to check for a combination of 4 ten hour shifts and 5 eight hour shifts. I then need to continue checking other possible combinations that would get the employee to 80 hours.

I know this equation below does not work, but this is what I am trying to do something similar to.

=IF(OR(ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"I","A","X","R","K","E","AL","FFSL","ADM*"})))=10,(ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"R-10","I-10","X-10","A-10"})))=4,AND(ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"I","A","X","R","K","E","AL","FFSL","ADM*"})))=5),"80 Hours","Error")

Essentially I am trying to embed an AND statement within the original OR statement. Not sure if that is even allowed. I am saying something like this:

IF 1 OR (2 AND 3) OR (3 AND 4), etc...

Thanks, 6StringJazzer. Unfortunately I am unable to change the layout of the schedule, however, I believe I found a way to get the equation to work. I changed the equation to this:

=IF(OR(ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"I","A","At","X","R","Rt","K","E","AL","TV*","FFSL","ADM*"})))=10, AND(ARRAYFORMULA(SUM(COUNTIF(B8:O8,{"R-10","I-10","X-10","A-10"})))=4, ARRAYFORMULA(SUM(COUNTIF(B7:O7,{"I","A","At","X","R","Rt","K","E","AL","TV*","FFSL","ADM*"})))=5)) ,"80 Hours","Error")

and it appears to work!