On Thu, 23 Jun 2005 15:32:37 -0400, Ron Rosenfeld
wrote:

On Thu, 23 Jun 2005 11:06:03 -0700, "Paulo Araújo" <Paulo
wrote:

I need help.
I've a sheet with one column with hour of some events. How can I count the
number events that happens in a certain interval of time. For exemple. "I
want to know the number of events that happens between 1:01 and 2:00 o'clock.

=COUNTIF(rng,"="&StartTime) - COUNTIF(rng,""&EndTime)

Format the result as General (Excel will try to format it as time).

You may need to play with the equality statements and your precise EndTime and
StartTime to get exactly the result you are looking for.

As written, with your times, the formula will give the number of instances

Including 1:01
All instances up and including 2:00

It will not give any instances prior to 1:01.


--ron

Just to elaborate, the StartTime and EndTime should be Excel times.

You could have them in cell references.

Or you could enter a formula such as TIME(1,1,0) for 1:01 AM; etc.




--ron