Excel, record IN and OUT time between specific tasks with multiple conditions -- 2

Hi, so what i really need is, if you take a look on the attached file, i need to record some times in "Master sheet" , pull the data from "Pivot Table Sheet" with these conditions: 1. IN TIME Action = "EXT Main Gate In (13) (In)" Date = report date from Master sheet (C2 cell) --Time = between 17:00 and 19:00 for "Yellow" and "Green" shift --Time = between 05:00 and 19:00 for "Blue" and "Red" shift If that event will happened more than once between 17:00 and 19:00 for "Yellow" and "Green", return first time. If that event will happened more than once between 05:00 and 07:00 for "Blue" and "Red", return first time. 2. OUT TIME Action = "EXT Main Gate In (13) (In)" Date = report date from Master sheet (C2 cell) for "Red" and "Blue" Date = report date from Master sheet (C2 cell)+1 for "Yellow" and "Green" Time between 05:00 and 07:00 for "Yellow" and "Green" Time between 17:00 and 19:00 for "Blue" and "Red" If that event will happened more than once between 05:00 and 07:00 "Yellow" and "Green", return LAST time. If that event will happened more than once between 17:00 and 19:00 for "Blue" and "Red", return LAST time. 3. Break time It is a variable, user can have 1/2/3 breaks. Maximum is 9. Time between 2 events GF WHS Out Turnstile (10) (In) - GF WHS In Turnstile (09) (In) For "Yellow" and "Green" Date between [report date from master sheet] and [report date from master sheet+1] time between 18:00 and 06:00 Fot "Blue" and "Red" date = [report date from master sheet] time between 06:00 and 18:00