7 Replies Latest reply: Jun 23, 2015 6:43 AM by jagan mohan rao appala RSS

    Calculating Employees Available at Interval

      Hi All ,

       

      Requirement is need to get the count of Employee based on the shift start , End TIme and Break Time.

       

      Input:

        

      PS IDDate[Log Type][Start Time][End Time]
      1236/1/2015LogIn/LogOff04/01/2015 05:00:00:00004/01/2015 15:00:00:000
      1456/1/2015LogIn/LogOff04/01/2015 09:00:00:00004/01/2015 18:30:00:000
      1786/1/2015LogIn/LogOff04/01/2015 13:00:00:00004/01/2015 21:00:00:000
      1236/1/2015Break04/01/2015 08:00:00:00004/01/2015 8:30:00:000
      1456/1/2015Break04/01/2015 11:00:00:00004/01/2015 11:15:00:000
      1786/1/2015Break04/01/2015 17:00:00:00004/01/2015 17:30:00:000

      Login/Logoff - > Shift start and end of each employee

      Break  - > Break should be subtracted based on the start and End Time.

       

      Expected Output :

       

      IntervalCount
      0 -10
      1 -20
      2-30
      3-40
      4-50
      5-61
      6-71
      7-81
      8-90.5
      9-102
      10-112
      11-121.75
      12-132
      13-143
      14-153
      15-162
      16-172
      17-181.5
      18-191.5
      19-201
      20-211
      21-220
      22-230
      23-240