Count number of cells fall within a certain timestamp

[tmcfann]

I have a tremendously large spreadsheet that displays a timestamp in one column per row of data like this: 04/15/2013 12:35:05 PM. It's all in the same cell - not separate. I want to create a function that will count how many cells fall at or before 11:00:00 AM. Help!

Thanks so much.

[Ace_XL]

Try

=SUMPRODUCT(--(MOD(A1:A100,1)<=11/24))

[tmcfann]

It worked!! Thank you SOOOOOOOOOOOOOO much!!!

[Tony Valko]

Here's another one.

Assumes no empty cells within the data range.

=SUMPRODUCT(--(HOUR(A1:A100)<=11))