COUNTIFS with Time Range criteria

[EvenS8245]

Good morning.

I'm having trouble getting a countifs formula to work for a specific time range. i'm working within 30 min increments. i need to return the count of orders received within each interval.

In the example below, i have attempted the following formula but it keeps returning 0, when it should be returning 6. There are 6 orders that came in between 12 am and 12:30 (formatted as 00:00 and 00:30)

=COUNTIFS(A:A,Table1[[#Headers],[Friday]],B:B,">=D2",B:B,"<D3")

I think the issue is criteria 2 and 3. When i click the formula bar, cells D2 and D3 are not highlighted.

are the quotes considering this as a text value?

 

[etaf]

should work
try
=COUNTIFS(A:A,Table1[[#Headers],[Friday]],B:B,">="&D2,B:B,"<"&D3)

=COUNTIFS($B$2:$B$18,">="&D2,$B$2:$B$18,"<="&D3)

Book1
	A	B	C	D	E
1
2		0:04		0:00	4
3		0:11		0:30	4
4		0:18		1:00	3
5		0:26		1:30	0
6		0:33		2:00	0
7		0:40		2:30	0
8		0:48		3:00	0
9		0:55		3:30	6
10		1:02		4:00	0
11		1:10		4:30	0
12		1:11		5:00	0
13		3:35
14		3:36
15		3:38
16		3:39
17		3:41
18		3:42
19
Sheet1

Cell Formulas
Range	Formula
E2:E12	E2	=COUNTIFS($B$2:$B$18,">="&D2,$B$2:$B$18,"<="&D3)
B3:B11	B3	=B2+0.0051
B12,B14:B18	B12	=B11+0.001
B13	B13	=B12+0.1

 

[EvenS8245]

that worked!!

thank you so much

 

[etaf]

you are welcome