=SUMPRODUCT(--(A1:A10<=--"07:00"),--(C1:C10--"08:00"),B1:B10)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Nick" wrote in message
...
hi there, still having trouble with this, i am trying to work out the
correct
formula to give me a head count from my excel based staff rota, the layout
is
below, what i need to count is the number of people at work between 07:00
and
08:00, 08:00 and 09:00 and so on.
06:00 1 15:00
09:00 1 15:00
07:00 1 16:00
07:00 1 15:00
09:00 1 15:00
11:00 1 17:00
thanks for any help you can give me :)
|