9:00 PM
8:04 PM
8:07 PM
9:01 PM
10:01 PM
10:03 PM
10:59 PM
11:09 PM
11:05 PM
11:59 PM
2 8-8:59 pm
2 9-9:59 pm
3 10-10:59 pm
0 11-11:59 pm
I am trying to take a long column of time entries (2107 of them) and count the number of times that fall within a specific hour. Using the formula below with only changes in times works fine except when I count the 11-11:59 PM. Could certainly use some help.
=COUNTIFS(E1:E10,">=11:00 PM",E1:E10,"<12:00 PM")
Bookmarks