If cell contains data then tell me if the next cell meets certain criteria

[wetsoks]

Hi, sorry im a relative beginner here in comparison.
I have 2 columns of data column A has the date and column b has the time.
Unfortunately column A is only populated once per day where as column B populates multiple times (up to 50) in the day.
What I want is if column A is not blank then tell me if the data in Column B is >09:00:00 or not

Ultimately I want to count the number of times the first login of the day is >09:00:00 in a month

I feel like i should be able to figure this out but its got me stumped can someone assist?

TIA

 

[etaf]

Ultimately I want to count the number of times the first login of the day is >09:00:00 in a month

=COUNTIFS(A:A,"<>",B:B,">="&TIME(9,0,0))

Book1
	A	B	C	D
2	1/1/20	7:00		4
3		9:30
4		12:00
5		14:30
6		17:00
7	1/2/20	19:30
8		22:00
9		0:30
10	1/3/20	3:00
11		5:30
12		8:00
13	1/4/20	10:30
14		13:00
15		15:30
16	1/5/20	18:00
17		20:30
18		23:00
19	1/6/20	1:30
20		4:00
21		6:30
22	1/7/20	9:00
Sheet3

Cell Formulas
Range	Formula
D2	D2	=COUNTIFS(A:A,"<>",B:B,">="&TIME(9,0,0))

 

[Peter_SSs]

I wouldn't use whole column references, and check whether you want an exact time of 9:00:00 to be included in the count or not.

count the number of times the first login of the day is >09:00:00

Adjust ranges if required.

21 01 02.xlsm
	B	C	D	E
1
2	1/01/2021	16:10:45		3
3		9:58:12
4		7:28:03
5	2/01/2021	3:46:22
6		1:41:18
7		4:58:35
8		21:29:08
9	3/01/2021	21:48:29
10		8:28:22
11		5:09:35
12	4/01/2021	11:31:35
13		3:08:08
14		9:53:13
15		5:36:47
16
COUNTIFS

Cell Formulas
Range	Formula
E2	E2	=COUNTIFS(B2:B100,">0",C2:C100,">"&9/24)

 

[wetsoks]

=COUNTIFS(A:A,"<>",B:B,">="&TIME(9,0,0))

Book1
	A	B	C	D
2	1/1/20	7:00		4
3		9:30
4		12:00
5		14:30
6		17:00
7	1/2/20	19:30
8		22:00
9		0:30
10	1/3/20	3:00
11		5:30
12		8:00
13	1/4/20	10:30
14		13:00
15		15:30
16	1/5/20	18:00
17		20:30
18		23:00
19	1/6/20	1:30
20		4:00
21		6:30
22	1/7/20	9:00
Sheet3

Cell Formulas
Range	Formula
D2	D2	=COUNTIFS(A:A,"<>",B:B,">="&TIME(9,0,0))

thank you!

 

[wetsoks]

thank you!

 

[Peter_SSs]

thank you!

You're welcome. Thanks for the follow-up.