4 Replies Latest reply: Sep 6, 2016 3:43 AM by Silambarasan Manickam RSS

    Finding Shift Time Difference..

    Silambarasan Manickam

      Hi,

       

      I have set of data's given below.

       

      EmpShiftInTimeShiftOuttimePunchinTimePunchOutTime
      A8:0020:008:3521:30
      A9:3021:309:3121:15
      B10:0022:009:3221:45
      C10:0022:009:5922:01
      D11:3023:3011:1523:15
      E5:3017:307:0017:15

       

      I want to calculate the person's who active who came >15 mts, who left >5mts, who came >30 mts based on their shiftintime & outtime for each employee.

       

      Could anyone help me with this