Showing hour blocks with average number of employees on shift using time clock data.

Hi, everyone. I am doing a timeclock analysis.

I have date, start time, end time, Employee ID, names, plus other columns to identify shift, dept, etc.

I have all the other deliverables required except this one that is troubling me.
I am hoping someone else has had this and can help steer me in the right direction.
I need to be able to show average number of employees on shift in hour intervals. I need to use actual timeclock times to get an average number of employees per hour. Example, if one person worked 30 min and another worked 1 hour in the specified hour, that would be 1.5 employees active on that hour. I also need to be able to input a specific date range to filter.

The dataset dates span about 6 months. I have about 1100 records with date time (mm/dd/yyyy hh:mm:ss). There are two shifts and second shift runs past midnight. For that reason, I need to use the date as a reference so the after midnight clock outs are associated with the start date.

I have tried a lot of things and haven't been able to resolve yet. Any help appreciated. Happy New Year!

UPDATE: my time values had to be rounded for them to work in logical formulas. Self-Resolved. Will remove file but keep post as it may help someone else.