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