1 2 Previous Next 27 Replies Latest reply on Jul 28, 2016 12:42 AM by Łukasz Majewski

    Calculate time difference with certain time range

    himhim chan

      Hi all,

       

      I have this data and want to calculate the time difference between two dates.

           

      EventStarting dateStarting timeEnd dateEnd Time
      A14/7/20168:0015/7/201614:30

       

      During starting time and end time, i would like to exclude non working hours:

      i.e. just count 9:00 to 17:00

       

      therefore the result of this example is:

      14/7/2016 9:00 to 17:00 = 8 hrs

      15/7/2016 9:00 to 14:30 = 5.5 hrs

       

      How to get 13.5 hrs as the result?

       

      Thank you

        1 2 Previous Next