Count cells in column that contain number in a range
"T. Valko" wrote in
:
Need some clarification...
Usually, when people say count between 10pm and 11pm what they really
mean is count *from* 10pm to 11pm. Counting "from" means to include
both 10pm and 11pm. Counting "between" technically means to exclude
both 10pm and 11pm.
===================
Yes I understand what you're asking I believe.
I want to count the first hour from 10:00PM to 11:00 pm.
Then the second hour would go from 11:01pm to 12:00pm.
Then from 00.01 AM to 01:00 am.
If an event happened at 10:00pm it would be counted in the first hour as
would an event at 11:00pm.
Ah I think I see a fallacy in my thinking. It should probably go from
10:00pm to 10:59pm then from 11:00 to 11:59pm etc. etc.
That may be why the results are so high. Events are possibly being double
counted.
But I don't understand the negative numbers being returned in 3 cases.
Hmmmm.
--
If you don't believe in Freedom of Speech for people you despise ... you
don't believe in it at all.
|