Countif
 

--------------------------------------------------------------------------------

I am trying to make a chart that will tell how many people are working in
any 24hour period.

I have the sample chart and shifts as

..........A.........B................C............ D
1......0600.....1430..........0400.....RESULT
2......0600.....1430..........0500.....RESULT
3......1200.....2030..........0600.....RESULT
4......2100.....0530..........AND CONTINUE TO 2400

I am using the formula of
=COUNTIF(A$1:A$4,"<=0")*AND(COUNTIF(B$1:B$4,"=0") )

This works great till I get to my overnight shifts and then it counts as
"False" and gives a result of 0.

I need a formula that would have countif column a and column b when true and
when column b less than column a it would count till 0530 in the morning.

Any help would be appreciated.

Thanks,
Mike