Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cells in column that contain number in a range
I have a column of times in 24 hour format. I want to have a formula that
counts the number of cells in the column that contain a time in a certain range. That is if the cell contains a time between 22:00 and 23:00 the cell should be counted. I will have to do that for each hour. I am trying to determine how many times during the night events happen in each time period. So I want to have a formula that counts the cells that fall within the time periods. I have tried =COUNTIF(I47:I3846,"23:01:<24:00")but it just returns zeros and I know there are cells with times in that range. All help / suggestions / solutions / jokes appreciated :) -- If you don't believe in Freedom of Speech for people you despise ... you don't believe in it at all. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
how to count number of highlighted cells in column | Excel Discussion (Misc queries) | |||
how do I count the number of gray-shaded cells within a range? | Excel Worksheet Functions | |||
count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel |