Checking for Time values

[SandsB]

I have a column (Column A) that shows the time people are scheduled to arrive for work:
06:30 AM
10:00 AM
09:30 AM, etc.

I want cell B2 to show the total number of cells from A1 to A30 that have a time value of 09:00 or greater. Anybody know how I could do this?

 

[barry houdini]

Hello SandsB

Try

=COUNTIF(A1:A30,">09:00")

 

[VoG]

Try

=COUNTIF(A:A,">=09:00")