I want to create a heatmap in Google Sheets that displays the most active hours for team members using conditional formatting. The first page has columns for each weekday and rows for each team member, with cells containing their start and end times. The second page has columns for each weekday and rows for each hour in a 24-hour cycle. I'm having trouble getting the number of people available at a given hour from the data on the first page. And it's hard for me to find the problem's source, since Sheets don't offer good solutions for debugging or doesn't give me an error.

input: