Calculate end timestamp from start timestamp and working hours
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)
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.