I need to figure out the count of shifts per interval per day for 3 months.

E.g. On Monday the 30th of October, I have 3 shifts starting at 9:00 to 5:30pm and 1 shift starting at 12:30 - 9:00pm - then count how many of these shifts are in each 30min interval. In this example, I should get 3 counts at 9AM, 3 counts at 9:30AM......4 counts at 12:30pm......1 count at 5:30pm...

The Countif formula works, but its not efficient when running on a 3month time range, and when you have different services.

I hope this clarifies