Thanks again. The was so simple, he said embarrassingly.

The formula (my actual with actual cells of the worksheet) is still not
resulting in the number of employees in the ranges across 2400.

=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,"")

Thanks,

Steve



"Bob Phillips" wrote:


"Steve" wrote in message
...
Thank you very much. Already it's saving a lot of time. However, a few,
hopefully minor, problems.
It's including the employees in the end time also. E.g., 0800-1100 should
not have employees in the 1100 column, as they're working 0800 until 1100,
not at 1100. Results are showing in the 1100 column also.

Change the = to

The other problem is that nothing is showing in any of the columns where
the
time range crosses midnight or starts with midnight. Data such as
2300-0100
or 2400-0200 does not produce any results. Midnight format is 2400,
however,
anything prior and including 2400 such as 2300-2400 does work, as does
after
such as 0100-0300.


=IF(OR(AND(--LEFT($A3,4)<=--C$1,--RIGHT($A3,4)--C$1),AND(--LEFT($A3,4)--RI
GHT($A3,4),OR(--LEFT($A3,4)<=--C$1,--RIGHT($A3,4)--C$1))),$B3,"")