Thx a lot for your help with my previous problem.
Now, I can plan a new order considering the pause and unplanned times of the shift calendar.
I need now to calculate a time, between 2 datetimes considering the shift calendar.
the shift calendar is configured with these parameters :
work days : moday -> friday
work hours : 8h00 -> 21h00
pause : 9h30 ->10h00
If I have 2 datetimes : 20h00 on monday & 11h00 on tueday
The time between these 2 datetimes is : 15h00
The "office" time between these 2 datetimes considering the shiftcalendar is : 3h30
I have only these 2 datetimes in a table, and I need to know how to calculate easily the "office" time considering the shift calendar parameters to put it in a new column.
Is there a method to do it ? A simple solution without to start a complex method ?
Thanks in advance !
Solved! Go to Solution.
please look at the index of the manual: calculateWorkingDuration.
Maybe you can solve your problem by this method of the Shiftcalendar object.