Trying to convert shift time to staffing numbers

[CJWFM]

I am trying to take the schedule's below and convert the to show how many agents should be working in each hour, I can't seem to debug the formula to calculate correctly.

 

[Fluff]

Is this what you want

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			7:00	0	0	0	0	0	0	0
3	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			8:00	16	16	16	16	16	0	0
4	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			9:00	16	16	16	16	16	0	0
5	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			10:00	16	16	16	16	16	0	0
6	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			11:00	16	16	16	16	16	0	0
7	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			12:00	16	16	16	16	16	0	0
8	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			13:00	16	16	16	16	16	0	0
9	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			14:00	16	16	16	16	16	0	0
10	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			15:00	16	16	16	16	16	0	0
11	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			16:00	16	16	16	16	16	0	0
12	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			17:00	16	16	16	16	16	0	0
13	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			18:00	0	0	0	0	0	0	0
14	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			19:00	0	0	0	0	0	0	0
15	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			20:00	0	0	0	0	0	0	0
16	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			21:00	0	0	0	0	0	0	0
17	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	08:00-17:00	off	off			22:00	0	0	0	0	0	0	0
18										23:00	0	0	0	0	0	0	0
Data

Cell Formulas
Range	Formula
K2:Q18	K2	=IFERROR(SUMPRODUCT((--LEFT(A$2:A$17,5)<=$J2)*(--RIGHT(A$2:A$17,5)>=$J2)),0)

 

[CJWFM]

Yes this is what I was looking for, also trying to account for lunches but not 100% sure if it is best to break the schedules into 2 halves or use another approach.