Count by date & time

[jamesraywebber]

I have a workbook with multiple sheets. One named TSA Daily & another one called TSA Support. In cell "B1" has a date and in the column on TSA Support (Column A) that has dates & time stamps.

I want "C5" on TSA Daily to count how many times the Column L has something in it if the date is equal to B1 with the time 8:00 AM - 8:59 AM.

 

[AhoyNC]

Depending on your ver. of Excel try either the COUNTIFS function in C5 or the SUMPRODUCT formula.

Excel Workbook
	A	B	C	D	K	L
1
2						11/28/2017 8:45
3						11/28/2017 8:50
4						11/28/2017 12:50
5			3			11/28/2017 13:50
6						11/29/2017 7:00
7			3			11/29/2017 8:00
8						11/29/2017 8:05
9						11/29/2017 8:55
10						11/29/2017 9:55
TSA Daily

Excel Workbook
	A	B	C
1		11/29/2017
2
TSA Support