15 Replies Latest reply: Oct 26, 2017 12:58 PM by Chris Casby RSS

    Identify two consecutive dates and get hours difference between it

    Jose Persichini

      Hello, I have this data from a fingerprint device:

       

      IDEmployee IDChecktimeChecktype
      1126/10/17 08:00:00In
      2226/10/17 08:10:00In
      3326/10/17 08:11:00In
      4226/10/1710:10:00Out
      5126/10/17 12:10:00Out
      6326/10/17 15:00:00Out
      7.........

       

      I want to know the hours worked for every employee in every day. For example I want to get:

       

      Employee IDDateHours worked
      126/10/176
      226/10/178
      3......

       

      So I need to get from every "In" row the next "Out" row for the same Employee ID and get the difference in hours between two dates.

       

      Any suggestion? Thanks!