Excel 2010 :: Count Max Time Frames Overlapping On Continuous Days

I'm having trouble defining the time overlaps on continuous days for the varying results of the runs for my simulation.

For the following data set, without counting overlaps there are 18 total spare requirements, but if I take into account their overlaps in their duration there should be a total of 11 per day. For example in row 4 this event overlapped in the same day with the event of row 5 so both had only 2 overlaps as a result (So there is not possible to be 1 as an answer for overlap, there is only from 2 to "n" amount or 0).

But if an event overlaps with more than one in their duration the result would be their maximum overlap during this time frame.

So then I have for each event an Starting date, starting time, duration, ending date and ending duration.And for each day I would need the total amount of overlaps occurred for the duration of each event and from those I would take their maximum amount of overlaps occurred per day. To obtain their real requirement as shown on the file.

The manual procedure I'm using looks like this for the first day: (Graphical representation)

Event 1 occurs from 17:02 to 20:29 and only overlaps with Event 3, so it's 2

Event 2 occurs from 20:38 to 23:38, also only overlaps with Event 3, then its also a 2

For Event 3 in its whole duration only overlapped with Even 1 and Event 2, one at a time so its maximum overlaps where only 2.

And that's what I'm using so far to determine these amounts but since is a simulation, I would end up with several data from each run and this method would be too long. That's why I would need this template to paste data for each run (15 days) and obtain my results faster.