topic Re: Network days function in QlikView https://community.qlik.com/t5/QlikView/Network-days-function/m-p/1008855#M645300 <HTML><HEAD></HEAD><BODY><P>Please try to avoid posting the same topic to multiple places.</P><P></P><P>You've already received some answers here:</P><P><A href="https://community.qlik.com/thread/193481">Networks days function</A></P></BODY></HTML> Mon, 30 Nov 2015 17:49:05 GMT swuehl 2015-11-30T17:49:05Z Network days function https://community.qlik.com/t5/QlikView/Network-days-function/m-p/1008854#M645299 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">Good day</SPAN></P><P></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">Please assist with a network days function that will exclude weekends<BR />and round off the days to 2 decimal places.</SPAN></P><P></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">Eg. 6 hours = 0.25 days&nbsp; or </SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">36 hours = 1.50 days or </SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">1 day 18 hours = 1.75 days</SPAN></P><P> </P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">This is for Turn Around Time (TAT) calculations.</SPAN></P><P> </P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">Regards</SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-themecolor: dark2;">Charles</SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:44:38 GMT https://community.qlik.com/t5/QlikView/Network-days-function/m-p/1008854#M645299 2015-11-30T12:44:38Z Re: Network days function https://community.qlik.com/t5/QlikView/Network-days-function/m-p/1008855#M645300 <HTML><HEAD></HEAD><BODY><P>Please try to avoid posting the same topic to multiple places.</P><P></P><P>You've already received some answers here:</P><P><A href="https://community.qlik.com/thread/193481">Networks days function</A></P></BODY></HTML> Mon, 30 Nov 2015 17:49:05 GMT https://community.qlik.com/t5/QlikView/Network-days-function/m-p/1008855#M645300 swuehl 2015-11-30T17:49:05Z