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
      5126/10/17 12:10:00Out
      6326/10/17 15:00:00Out


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


      Employee IDDateHours worked


      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!