1 Reply Latest reply: May 26, 2017 12:23 PM by Bill Markham RSS

    Get your thinking caps on! Want to chart clockin/outs and time between

    Bill Uran

      Hello All, This is one where i think we can all work together on: I have created a solution in excel, but i want to take it into qlik.

       

      I want to count the number of employees working every half hour (or a designated time increment) by when they clocked in and out.

      Example:

      Date Set

      Employee IDTime Stamp InTime Stamp Out
      11/7/17 8:001/7/17 23:00
      21/7/8:001/7/17 15:00
      31/7/10:001/7/1714:00

       

       

       

      Things to consider: Want to be able to filter by day of week and if the time goes over midnight to the next day need to assign remaining hours to the next day or days.

       

      Lets do this!!

       

      Bill