Calculate start from end and duration without weekends

[Luca_Sh]

Hi all,

Im new here and need your help to calculate some data.

Im creating an app to visualise order and its operations. (planning board).

All I have is order number, operation number, duration of each operation and finish date of order.

I need to calculate backwards start and end date and time of operations, based on duration.

Exceptions are weekends (Saturday, Sunday, Holidays). Worktime is 7-22. Operations do not overlay.

When operation is long and it will be on weekend, I need to split it into segments, one due to weekend start and then after weekend. so if operation is 32 hours long and finish will be monday 15:00, start will be calculate to thursday 13:00.

Thanks

[skamath1]

You can use the networkdays function to compute the duration. Check the help for details and examples 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...