Understand the confidentiality in your industry
see the link attached Showing Records That Fall Within a Period of Time | Tableau Software
I have used the process before and it does work - the problem is not identical but similar - counting records (patients) when records have a start and end date
your's is more detailed at the hour level but the process is the same - If you still need some help let me know
Just out of curiosity, do you just want it every hour on the hour?
I debated this before while working on census dashboards and opted to use the max census per hour as I felt it was important to know the absolute busiest time in order to ensure we were properly staffed.