Help creating a formula

[Dayski147]

Help creating a formula in the attached file
Required number of employees for this day by hour from - to It means the number of employees between 9:00 am and 10:00 pm

Book1(1).xlsx

Shared with Dropbox

www.dropbox.com

 

[etaf]

this is duplicated - i answered here

Find a formula for calculating the number of workers at the same time

Welcome. Is there a way in Excel to calculate the number of workers in the factory at the same time, there is a column for log-in and a column for log-out

www.mrexcel.com

But now i have a file i will look at that and reply

 

[etaf]

here is the countifs()

but it will only be on the share for a few days

Book1(ETAF).xlsx

Shared with Dropbox

www.dropbox.com

Book1(ETAF).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1																	اعداد الموظفين
2		AGENT NAME	Sat		Sun		Mon		Tue		Wed		Thu		Fri		FROM	TO	SAT	SUN	MON	TUE	WED	THU	FRI
3			8/21/22		8/22/22		8/23/22		8/24/22		8/25/22		8/26/22		8/27/22		9:30 AM	10:00 PM	2	1	1	0	0	0	1
4			FROM	TO	FROM	TO	FROM	TO	FROM	TO	FROM	TO	FROM	TO	FROM	TO
5	1	david	9:30 AM	6:30 PM											10:00 AM	11:00 AM
6	2	badr	12:00 AM	9:30 PM	12:00 PM	10:30 AM			9:00 AM	9:30 AM
7	3	maya	11:30 AM	8:30 PM			11:00 AM	11:30 AM
8	4
9	5
10	6
11	7
12	8
13	9
14	10
15
16
17
18
Sheet2

Cell Formulas
Range	Formula
S3	S3	=COUNTIFS(C$5:C$12,">="&$Q3,D$5:D$12,"<="&$R3)
T3	T3	=COUNTIFS(E$5:E$12,">="&$Q3,F$5:F$12,"<="&$R3)
U3	U3	=COUNTIFS(G$5:G$12,">="&$Q3,H$5:H$12,"<="&$R3)
V3	V3	=COUNTIFS(I$5:I$12,">="&$Q3,J$5:J$12,"<="&$R3)
W3	W3	=COUNTIFS(K$5:K$12,">="&$Q3,L$5:L$12,"<="&$R3)
X3	X3	=COUNTIFS(M$5:M$12,">="&$Q3,N$5:N$12,"<="&$R3)
Y3	Y3	=COUNTIFS(O$5:O$12,">="&$Q3,P$5:P$12,"<="&$R3)

Cells with Data Validation
Cell	Allow	Criteria
C5:P18	List	=time1
Q3:R3	List	=time1