Employees across midnight (2200-0100) -repost (attn: Bob)

[Steve]

I apologize for starting a new thread, but my last post may not have showed
on the board.

OK, great. Here's what I have. The actual cells are in ( )

(aw2) (ax2) (ay2) (az2)
Period Total Count 2200 2230 2300 2330
(c20)2100-2400 (t20) 1 1 1 1 1
(c21)2200-0100 (t21) 4

Here' s the formula in cell aw20
=IF(OR(AND(--LEFT($C20,4)<=--AW$2,--RIGHT($C20,4)>--AW$2),AND(--LEFT($C20,4)>RIGHT($C20,4),OR(LEFT($C20,4)<=--AW$2,--RIGHT($C20,4)>--AW$2))),$T20,"")
It correctly produces the 1's from 2100-2300

Here's the formula for cell aw2
=IF(OR(AND(--LEFT($C21,4)<=--AW$2,--RIGHT($C21,4)>--AW$2),AND(--LEFT($C21,4)>RIGHT($C21,4),OR(LEFT($C21,4)<=--AW$2,--RIGHT($C21,4)>--AW$2))),$T21,"")
It does not produce the expected 4's from 2200-2400

Thanks again,

Steve