| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells between two times
I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident occurs between certain times (eg 7am and 11am) by using the countif function with variations on the following formula =countif(B:B, "=07:00:00 & <11:00:00") but it is not calculating it correctly. Can somebody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting event times | New Users to Excel | |||
| counting how many times something happens in a week | Excel Discussion (Misc queries) | |||
| Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) | |||
Threaded Mode
