COUNT HOW MANY PEOPLE WORKS BETWEEN TIME CELLS

[othmannl]

Hi,

I have a schedule of employees, that works in shifts.

But i want to count how many people are working
between 07:00 and 12:00
and between 12:00 and 16:00
and between 16:00 and 20:00

How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down picture for how it looks like

Thanks in advance

 

[fadee2]

how about countif?

Book8
	A	B	C
1	Name	in	out
2	a	7:00	12:00
3	b	7:00	11:59
4	c	12:00	15:00
5	d	12:00	16:00
6	e	16:00	19:00
7	f	16:00	20:01
8
9	07:00-12:00	12:00-16:00	16:00-20:00
10	2	2	1
Sheet1

Cell Formulas
Range	Formula
A10	A10	=COUNTIFS(B2:B7,"7:00",C2:C7,"<=12:00")
B10	B10	=COUNTIFS(B2:B7,"12:00",C2:C7,"<=16:00")
C10	C10	=COUNTIFS(B2:B7,"16:00",C2:C7,"<=20:00")

 

[othmannl]

how about countif?

Book8
	A	B	C
1	Name	in	out
2	a	7:00	12:00
3	b	7:00	11:59
4	c	12:00	15:00
5	d	12:00	16:00
6	e	16:00	19:00
7	f	16:00	20:01
8
9	07:00-12:00	12:00-16:00	16:00-20:00
10	2	2	1
Sheet1

Cell Formulas
Range	Formula
A10	A10	=COUNTIFS(B2:B7,"7:00",C2:C7,"<=12:00")
B10	B10	=COUNTIFS(B2:B7,"12:00",C2:C7,"<=16:00")
C10	C10	=COUNTIFS(B2:B7,"16:00",C2:C7,"<=20:00")

Thanks, but what if soemone works from 09:00 - 18:00, that means that he is available between 7:00 and 12:00 \\\ and also between 12:00 and 16:00