counting time slots

G

Guest

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 :)
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A10<=--"07:00"),--(C1:C10>--"08:00"),B1:B10)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif with time 3
still having trouble with this.... 4
Peak call times/hours 2
airline standby worksheet 7
Countifs with different restrictions 1
Conditional Time Calculation 10
Time query 9
calculate cells with format hh:mm 4

Top