Trying to get Totals per Time and Date

Hi All,
Im trying to get a formula to work for my count of personnel per dayshift (Z1:Z6 to AA1:AA6) and per night shift (Z7:Z11 to AA7:AA11) (both seperated in totals) for each Vendor by using column (Q,R) and Vendor (L)
My first try highlighted in Orange was basic but didnt include/exclude certain times (before or after) or include vendor.

Now to be a real pain is there a way I can exclude a total count if it creeps before or after the set shift times by say 1/2 hour - 1 hour either way. (Would it be excluded by a percentage add in of before/after shifts????)

Any Help would be much appreciated