CountIf falls between times

Hi,

I'm looking for some help coming up with a formula for the attached worksheet.

In the table of cells A3:G12 there is a list of staff I have working that day and the hours that they are working, which I enter manually.

The table A14:G89 is a list of matches that my staff will be monitoring which I paste in from a downloaded list. Column G is blank when I paste is filled in by the table on the right which is what I want to achieve at then end.

Once I have entered the times that people are working that day then scroll over to the right and look to fill in the column headed 'Monitoring'.

What I want help with is the 'Schedule Table' at the top of the worksheet. What I want to do here is place a formual in these cells to display how many matches a member of staff is monitoring concurrently at any given 15 minute interval. I've filled in down to the 11.05 kick-off to show what I want it to display but obviously I want to find a formula to replace this manual intervention.

Many thanks,
Adam.