5 Replies Latest reply on Feb 11, 2019 5:04 AM by Zhouyi Zhang

    Night Shift Handling( Filter work time date vise)

    pinki sharma

      Hi Experts,

       

      I am working on night shift cleaning data. I have time stamps like site_entered_at and site_left_at etc. Eg - If an employee enters in site at 01/02/2019 22:00:00 and he left site at 02/02/2019 3:00:00. total work time will be 5 hours.i want to filter work time date vise. If i put filter on 01/02/2019 date then worktime should be 2 hours and if 02/02/2019 is selected as date then worktime should be 3 hours.

       

      Any quick help would be much appreciated.

      Data -

       

       

       

      Regards,

      Pinki Sharma