I have a lot of requests coming in with the following timestamp (Created time Column) and I would like to quickly be able to count how many requests came in during each hour. I found I can get a code to work if I manually delete the date information, but if I change the format from number to date and only show the timestamp then the formula below doesn't work.
How can I get the formula to ignore the date? I don't want to have to manually update that column each day I update this report.
=countifs(C2:C,">=07:00:00",C2:C,"<=08:00:00")