How can I create a 24-hour time period "occupancy" chart in Excel?
Matthew Barrera 
(First time posting, long time lurking, thanks!)
I'm trying to create a time series of site 'occupancy' - Basically, how many people are logged into the site over a given time period. Along the x-axis is a 24-hour time period (or it can be for more than just 24 hours); and on the y-axis is the total number of users. So I believe it'd look like a density plot. However, I'm not sure how to do this with multiple users over non-discrete time values.
The data are formatted in Excel as a custom date and time (mm/dd/yyyy hh:mm:ss). They look like this, covering multiple days:
User ID#; In Time; Out Time;
#1 - 08/09/2020 02:02:04 AM - 08/11/2020 19:02:12 PM
#512 - 08/09/2020 08:30:05 AM - 08/10/2020 14:35:00 PM
#30 - 08/14/2020 04:56:44 AM - 08/15/2020 08:40:17 AM
Does anyone have any ideas on how to use the "in" and "out" times to calculate when someone enters and then leaves (along the x-axis), while 'adding' together all the people present at a given time (along the y-axis)? (And if this question already exists, please let me know!)
Thank you very much for sharing your time and help!
4 Reset to default
