1 2 Previous Next 21 Replies Latest reply on Dec 22, 2019 12:27 PM by Soumitra Godbole

    Time series/total time someone was present at the counter

    Lipi Soni

      I want to calculate total time when a employee was present at the counter on 11/20/2019 from 9am-10am. There can be 2 employees during the same time, so we cannot sum the time difference. How do I plot the percentage or total time someone was there at the front counter?

       

        employee     zone               arrival                                        departure

           1               Counter          11/20/2019  9:34:52 AM          11/20/2019  9:35:02 AM

           2               Counter          11/20/2019  9:29:34 AM          11/20/2019  9:29:46 AM

           3               Counter          11/20/2019  9:30:08 AM           11/20/2019  9:25:46 AM

           2               Counter          11/20/2019  9:40:34 AM          11/20/2019  9:45:46 AM

           3               Counter          11/20/2019  9:37:08 AM           11/20/2019  9:50:46 AM

        1 2 Previous Next