View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

If they are stored as actual times, try something like this with your times
in B5:B8.

=SUMPRODUCT((24*(B5:B8)=1)*(24*(B5:B8)<2))


"Paulo Araújo" <Paulo wrote in message
...
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.