topic Re: Intervalo Comercial in Brasil https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490791#M13827 <HTML><HEAD></HEAD><BODY><P>Obrigado Carlos. </P></BODY></HTML> Thu, 18 Jul 2013 20:43:28 GMT valerioms 2013-07-18T20:43:28Z Intervalo Comercial https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490789#M13825 <HTML><HEAD></HEAD><BODY><P>Bom dia!</P><P>Tenho um campo Data Inicial '01/07/2013 11:00:00' e outro Data Final '15/07/2013 19:30:00'. Como fazer para descobrir neste período o intervalo comercial considerando-se apenas os dias úteis e horário de atendimento de 9 às 18 hs? No aguardo, obrigado a quem responder. </P></BODY></HTML> Wed, 17 Jul 2013 12:11:40 GMT https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490789#M13825 valerioms 2013-07-17T12:11:40Z Re: Intervalo Comercial https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490790#M13826 <HTML><HEAD></HEAD><BODY><P>Boa Tarde.</P><P></P><P></P><P>Fiz um exemplo aqui, utilizando as formulas</P><P></P><P>Dias Comerciais --&gt; =NetWorkDays(entrada,saida)&nbsp; --&gt; Retorno 11 Dias</P><P>Horas Comercias--&gt; =NetWorkDays(entrada,saida)*8&nbsp; --&gt; 88 Horas</P><P></P><P>Considerando 8 horas diarias.</P><P></P><P></P><P>Att.</P><P></P><P>Carlos de Sá</P></BODY></HTML> Thu, 18 Jul 2013 18:05:02 GMT https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490790#M13826 2013-07-18T18:05:02Z Re: Intervalo Comercial https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490791#M13827 <HTML><HEAD></HEAD><BODY><P>Obrigado Carlos. </P></BODY></HTML> Thu, 18 Jul 2013 20:43:28 GMT https://community.qlik.com/t5/Brasil/Intervalo-Comercial/m-p/490791#M13827 valerioms 2013-07-18T20:43:28Z