topic Re: How to get duration time excluding weekend in QlikView https://community.qlik.com/t5/QlikView/How-to-get-duration-time-excluding-weekend/m-p/612951#M681939 <HTML><HEAD></HEAD><BODY><P>Ahyel,</P><P></P><P>The <STRONG>networkdays</STRONG>() function should suit you.</P><P>it accepts two arguments: first date, last date</P><P></P><P>Fabrice</P></BODY></HTML> Fri, 07 Mar 2014 08:51:19 GMT 2014-03-07T08:51:19Z How to get duration time excluding weekend https://community.qlik.com/t5/QlikView/How-to-get-duration-time-excluding-weekend/m-p/612950#M681938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone help me on how will I get the duration time from transmittal date to clearing date excluding weekends? Sample data provided below</P><P><IMG alt="0000111.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/54482_0000111.JPG.jpg" style="width: 620px; height: 114px;" /></P><P>Thank you so much!</P><P></P><P>Ahyel</P></BODY></HTML> Fri, 07 Mar 2014 08:10:05 GMT https://community.qlik.com/t5/QlikView/How-to-get-duration-time-excluding-weekend/m-p/612950#M681938 2014-03-07T08:10:05Z Re: How to get duration time excluding weekend https://community.qlik.com/t5/QlikView/How-to-get-duration-time-excluding-weekend/m-p/612951#M681939 <HTML><HEAD></HEAD><BODY><P>Ahyel,</P><P></P><P>The <STRONG>networkdays</STRONG>() function should suit you.</P><P>it accepts two arguments: first date, last date</P><P></P><P>Fabrice</P></BODY></HTML> Fri, 07 Mar 2014 08:51:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-duration-time-excluding-weekend/m-p/612951#M681939 2014-03-07T08:51:19Z