1 Reply Latest reply on Sep 20, 2017 9:40 AM by patrick.byrne.0

    Row Wise TAT and Exclude Holidays basis specified list and include only 9 hrs a day

    Varun Vijayasarathy

      Hi Guys,

       

      Request your support in arriving at ROW wise TAT for the below sample data and also exclude  ( holidays as per defined list ) Pl let know how to link this .

      Also need to include only 9 hours a day .

                                                                                                                                                                                                                                                     

      cidTIDParty_IdinsertDateStatusDateOfActionTAT to be arrived@Remarks
      5464984567568992017-07-13 17:25:43.053AUTHORIZED BY CENTRAL2017-07-27 17:27:05.1130:00:59Exclude Holidays -   Specified list to be uploaded
           Include only 9 hrs a day
      5464983567568992017-07-13 17:25:43.053AUTHORIZED BY CENTRAL2017-07-27 17:26:05.8631:48:36
      5464942567568992017-07-13 17:25:43.053SENT TO CENTRAL2017-07-27 15:37:30.2470:33:02
      5464925567568992017-07-13 17:25:43.053SENT TO LOCAL2017-07-27 15:04:28.3300:00:00
      5464924567568992017-07-13 17:25:43.053REJECTED BY CENTRAL2017-07-27 15:04:28.3301:50:44
      5464895567568992017-07-13 17:25:43.053SENT TO CENTRAL2017-07-27 13:13:43.8630:10:15
      5464892567568992017-07-13 17:25:43.053SENT TO LOCAL2017-07-27 13:03:28.4700:00:00
      5464891567568992017-07-13 17:25:43.053REJECTED BY CENTRAL2017-07-27 13:03:28.47019:35:29
      5464755567568992017-07-13 17:25:43.053SENT TO CENTRAL2017-07-26 17:27:59.7470:33:36
      5464745567568992017-07-13 17:25:43.053Pending At LOCAL2017-07-26 16:54:24.083120:52:24
      5464291567568992017-07-13 17:25:43.053SENT TO RM2017-07-21 16:01:59.95028:12:56
      5464034567568992017-07-13 17:25:43.053SENT TO LOCAL2017-07-20 11:49:03.8830:00:00
      5464033567568992017-07-13 17:25:43.053REJECTED BY CENTRAL2017-07-20 11:49:03.88320:41:45
      5463939567568992017-07-13 17:25:43.053SENT TO CENTRAL2017-07-19 15:07:18.4904:20:49
      5463879567568992017-07-13 17:25:43.053Pending At LOCAL2017-07-19 10:46:29.270137:20:46
      5463467567568992017-07-13 17:25:43.053Pending At RM2017-07-13 17:25:43.057N.A.