Hi guys,
I'm trying to use this formula
=COUNTIF(A:A, ">B1")
trying to count the number of events which occur before the time specified in B1.
I have two questions:
1) the formula returns nothing when i do this. B1 contains both date and time, eg. 1/1/2005 1:00. When i enter this formula =COUNTIF(A:A, ">1/1/2005 1:00"), the formula works fine. How can i get the first formula to work?

2) Second problem is that i'm trying to count the no. of events that occur for example between 10:00 and 11:00 of the same day for example. With the above formula, i have to find the no. of events before each hour and subtract from the next one and so on. Is there an easier formula that i could use, for example
=COUNTIF(A:A, AND(">B1", "<B2"))

Appreciate an answer/ solution asap. thanks guys.