=SUMPRODUCT(--(B2:B20=--"05:00:00"),--(C2:C20<=--"11:00:00"),F2:F20)

=SUMPRODUCT(--(B2:B20=--"11:00:00"),--(C2:C20<=--"13:30:00"),F2:F20)

--
Regards,
Tom Ogilvy


"Sonic" wrote in message
...
Great thats prefect now a seacond part to that would be if i could pull
the
total pay that was payed out for my diffrent shifts

"Bob Phillips" wrote:

=SUMPRODUCT(--(B2:B20=--"05:00:00"),--(B2:B20<=--"11:00:00"))

=SUMPRODUCT(--(B2:B20=--"11:00:00"),--(B2:B20<=--"13:30:00"))

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sonic" wrote in message
...
OK heres a good one for you guys to help me with

A B C D E F
1Name In Out Total Pay Total
Employee Time Time Time Rate Pay

2 Sean 5:00 am 1:00 pm 8 $7.00 $56.00

Now On Sheet2 I want to pull the number of hours that sean worked
between
my
shift which are 5 to 11am, 11am to 1:30pm, 1:30 to 5:00pm 5 to 8pm and
8
to
12am. So if it works it would tell me that i had one employee for shift
5
to
11 and one for 11 to 1:30. Simple Right at least i hope so.
Thanks in advance