3 Replies Latest reply: Feb 4, 2015 3:56 AM by Gabriele Boccassini RSS

    Calculate end timestamp from start timestamp and working hours

    Gabriele Boccassini

      Hi,

      I have a problem for calculate final timestamp in my load script.

      My working hours are 9:00-13:00 and 14:00-18:00

       

      I have a initial timestamp and  a working duration hours for an activity. For example:

       

      Start (DD/MM/YYYY hh:mm:ss)Interval (hh:mm:ss)
      01/02/2015 12:50:0000:20:00

       

      I want to calculate the final timestamp.

      For the example in the table the final timestamp is 01/02/2015 14:10 because the time from 13:00 to 14:00 not must be considered. The same logic must be used for the time in the holidays day (all the day) and from 18:00 to 9:00.

       

      Ideas?

       

      thanks,

      Gabriele