ExcelBanter - head count on rota

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - head count on rota (https://www.excelbanter.com/excel-worksheet-functions/16869-head-count-rota.html)

head count on rota

anyone know how i can get excel to count the number of people i have between
7-8 , 8-9, 9-10 etc. i have created the rota in excel all times are in HH:MM
format using seperate columns for start and finish time.
e.g.
in b out
06:00 1 15:00
06:00 0 13:00
06:00 1 14:00

06:00 1 15:00
09:00 1 15:00
07:00 1 16:00

Hi!

Try one of these.

=SUMPRODUCT(--(A2:A8=TIME(7,0,0)),--(C2:C8=TIME
(8,0,0)),B2:B8)

OR, enter your time ranges in cells:

E1 = 7:00 AM
F1 = 8:00 AM

=SUMPRODUCT(--(A2:A8=E1),--(C2:C8=F1),B2:B8)

Biff

-----Original Message-----
anyone know how i can get excel to count the number of
people i have between
7-8 , 8-9, 9-10 etc. i have created the rota in excel
all times are in HH:MM
format using seperate columns for start and finish time.
e.g.
in b out
06:00 1 15:00
06:00 0 13:00
06:00 1 14:00

06:00 1 15:00
09:00 1 15:00
07:00 1 16:00

.