Charting 24 hour days for each month with three criteria

Hi;
I need to chart/graph admits, discharges in acute care along with emergency room census.
Components:

• 24 hours
• 30-31 days(Monthly)
• Number of discharges at a given time
• Number of admits at a certain time
• Number of ER visits at a certain time

The point is to see where the most activity is happening on what day and or time period to add staff if needed.

This attached spreadsheet is NOT the real data, but it has the titles of what I need.
I don't now how to set this up.

Any suggestions?
I am familiar with pivot tables, if that is an option.

THANK YOU!!!!!!!!!!!
This forum is amazing.