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