https://community.qlik.com/t5/QlikView/Calculate-start-from-end-and-duration-without-weekends/m-p/1783829#M1209798 <P>Hi all,</P><P>Im new here and need your help to calculate some data.</P><P>Im creating an app to visualise order and its operations. (planning board).</P><P>All I have is order number, operation number, duration of each operation and finish date of order.</P><P>I need to calculate backwards start and end date and time of operations, based on duration.</P><P>Exceptions are weekends (Saturday, Sunday, Holidays). Worktime is 7-22. Operations do not overlay.</P><P>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.</P><P>Thanks</P> Thu, 18 Feb 2021 13:38:08 GMT Luca_Sh 2021-02-18T13:38:08Z https://community.qlik.com/t5/QlikView/Calculate-start-from-end-and-duration-without-weekends/m-p/1783829#M1209798 <P>Hi all,</P><P>Im new here and need your help to calculate some data.</P><P>Im creating an app to visualise order and its operations. (planning board).</P><P>All I have is order number, operation number, duration of each operation and finish date of order.</P><P>I need to calculate backwards start and end date and time of operations, based on duration.</P><P>Exceptions are weekends (Saturday, Sunday, Holidays). Worktime is 7-22. Operations do not overlay.</P><P>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.</P><P>Thanks</P> Thu, 18 Feb 2021 13:38:08 GMT https://community.qlik.com/t5/QlikView/Calculate-start-from-end-and-duration-without-weekends/m-p/1783829#M1209798 Luca_Sh 2021-02-18T13:38:08Z https://community.qlik.com/t5/QlikView/Calculate-start-from-end-and-duration-without-weekends/m-p/1783830#M1209799 <P>You can use the networkdays function to compute the duration. Check the help for details and examples&nbsp;</P><P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/networkdays.htm" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/networkdays.htm</A></P> Thu, 18 Feb 2021 13:40:16 GMT https://community.qlik.com/t5/QlikView/Calculate-start-from-end-and-duration-without-weekends/m-p/1783830#M1209799 skamath1 2021-02-18T13:40:16Z