Finding a Function to Total by Date/Time

[ohlrj]

Good morning everyone!

I'm in the process of putting together an hourly work chart for my organization, and one of my inputs has generated a montly report that has about 4000 lines. The date and time information is located in the same column. What I would like to do is have a function that I can run that will allow me to pick out my data by day and hour. For example, rather than manually counting how many occurances happened between 0:00 and 1:00 on 8/1, between 1;00 and 2;00 on 8/1, etc, I'd like Excel to do it for me . I have attached a copy of the sheet I'm working with (the extra columns contain proprietary information and have been removed).

Any help is much appreciated!