Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Employees across midnight (2200-0100) -repost (attn: Bob)
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 aw21 =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 "Bob Phillips" wrote: Steve, It worked in my test, but it might be that my layout differed from yours. Can you post the data just the first few columns and the last few, with examples as you did before. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|