Calculating schedule overlap

I am trying to create a spreadsheet that will calculate the hours the total hours of overlap in schedule between the supervisor and each of their team members and also a total for all the teams.

The purpose so you can understand. Within the company we have multiple teams. We try to schedule supervisors as closely as possible with the CSRs but the scheduling doesn’t always work out and sometimes a CSR may have to work hours or days that are different from their supervisor. The attachment shows an example of 2 teams. What I need is for the spreadsheet to do is to take the csrs schedule (days and hours) and cross reference it with the supervisors schedule and calculate the total number of overlapping hours so that I can determine how many hours the supervisor has available to work with their subordinates. For example if a csr works 8-430 m-f but their supervisor works 9-530 Tuesday-sat. they only have 4 days together and a total of 7 hours per day (not including lunch). So out of the 40 hours scheduled to work they only overlap for 28 hours so the percentage of time available for coaching, and support is 70% because of the difference in schedule time and days of the week. I am trying to figure this out for about 35 teams and almost 500 people so going through and manually calculating each person is far too time consuming. Any help would be greatly appreciated. Thanks.

(YSMTWRF=Saturday, sunday, Monday, Tuesday, Wednesday, Thursday, Friday)Book2.xlsx

Hopefully this is what you're looking for. It's based on a total percentage of the employee's total hours... not the supervisors.

Supervisor Overlap.xlsx