https://community.qlik.com/t5/Brasil/Calculo-de-Banco-de-horas/m-p/1622281#M57646 <P>Prezados, boa tarde</P><P>Estou tentando calcular a quantidade de horas positivas de um banco de horas.</P><P>//sum(( num_horar_term_mpe)-( num_horar_inic_mpe ) )/3600</P><P>&nbsp;</P><P>onde:&nbsp; Time(num_horar_term_mpe,'hh:mm:ss') as num_horar_term_mpe,<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time(num_horar_inic_mpe,'hh:mm:ss')as num_horar_inic_mpe,&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>o resultado nao bate com um formato de data.</P><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/18882iA989414F911324E4/image-size/medium?v=1.0&amp;px=-1" border="0" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></P><P>&nbsp;</P><P>Se puderem me ajudar ficaria muito agradecido.</P> Tue, 10 Sep 2019 18:29:11 GMT Sidarta 2019-09-10T18:29:11Z https://community.qlik.com/t5/Brasil/Calculo-de-Banco-de-horas/m-p/1622281#M57646 <P>Prezados, boa tarde</P><P>Estou tentando calcular a quantidade de horas positivas de um banco de horas.</P><P>//sum(( num_horar_term_mpe)-( num_horar_inic_mpe ) )/3600</P><P>&nbsp;</P><P>onde:&nbsp; Time(num_horar_term_mpe,'hh:mm:ss') as num_horar_term_mpe,<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time(num_horar_inic_mpe,'hh:mm:ss')as num_horar_inic_mpe,&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>o resultado nao bate com um formato de data.</P><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/18882iA989414F911324E4/image-size/medium?v=1.0&amp;px=-1" border="0" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></P><P>&nbsp;</P><P>Se puderem me ajudar ficaria muito agradecido.</P> Tue, 10 Sep 2019 18:29:11 GMT https://community.qlik.com/t5/Brasil/Calculo-de-Banco-de-horas/m-p/1622281#M57646 Sidarta 2019-09-10T18:29:11Z