Thread
:
Counting cells with intervals
View Single Post
#
2
Dave R.
Posts: n/a
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.
Reply With Quote