Hi Community,
Can you please help me understand how can I filter out on Min/Max time based on locations. Please see the scenario below and find attached excel and package workflow for reference. Thanks in advance.
Scenario:
There are only two entrance doors a person can use to get into the premises. (HMGBR5_Main_IN & HMGBR5_SNEAK_IN). Similarly, there only two exit doors. (HMGBR5_Main_OUT & HMGBR5_SNEAK_OUT).
- Batman - Batman is a shift worker start in the middle of the night and finished in the morning. Even though he used SNEAK_IN & MAIN_IN doors but his Start Time will be 12:22:57 a.m. for 13th Sept 2020 as he used that does to come in at the first instance on that day. His finish time is 9:59:55 a.m.
- Charlie - Charlie is a shift pre-grave shift worker starts at 16:16:15 p.m. on 13th September 2020 and continues to work until next morning. But, technically he did not finish on 13th Sep 2020. So, below is the desired outcome for him.
Desired output:
One card number/name per row per day as per desired output tab in excel
