8 Replies Latest reply: Jul 31, 2017 2:05 PM by Sunny Talwar RSS

    business hours and rest as non business hours.

    Surendra kumar

      HI All,

       

      I Have date data below.

      i need to calculate time between 8:00 to 20:00 as business hours and rest as non business hours.

       

      DateTime
      11/16/2016 15:00
      11/16/2016 15:30
      11/17/2016 14:30
      11/21/2016 9:30
      11/21/2016 10:00
      11/21/2016 10:30
      11/21/2016 11:00
      11/21/2016 11:30
      11/22/2016 7:30
      11/22/2016 12:00
      11/23/2016 11:30
      11/24/2016 11:30
      11/29/2016 9:30
      12/1/2016 10:30
      12/1/2016 11:00