View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
az willie az willie is offline
external usenet poster
 
Posts: 5
Default 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.