countif times in a list by the hour in excel
Posted on 2011-09-21
I have a list of times that are formatted like 03:12:00 PM. I want to categorise each time by the hour using countif so my output will show how many are in each group.
12:00 AM to 1:00 AM 20
1:00 AM to 2:00 AM 13
3:00 AM to 4:00 AM 40
I also have one other text column that will be used to filter which dates to count. This is what I have so far:
=COUNTIFS( 'Requests RAW'!$AA:$AA,"<"&Z6,'Requests RAW'!$D:$D,$H$4)-COUNTIFS( 'Requests RAW'!$AA:$AA,"<"&Z7,'Requests RAW'!$D:$D,$H$4)
Z6 is start time and z7 is end time, any ideas?