https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1633943#M57901 <P>Boa tarde,</P><P>Quero subtrair horas do campo data, é possível ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21211i6EFF1C294DFF6AE8/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P> Thu, 10 Oct 2019 19:20:45 GMT Neto_Braga 2019-10-10T19:20:45Z https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1633943#M57901 <P>Boa tarde,</P><P>Quero subtrair horas do campo data, é possível ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21211i6EFF1C294DFF6AE8/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P> Thu, 10 Oct 2019 19:20:45 GMT https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1633943#M57901 Neto_Braga 2019-10-10T19:20:45Z https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1634297#M57909 <P>Olá;</P><P>Meu amigo, tente:</P><P>Date( Floor( Timestamp#([SEU_CAMPO_DATA_HORA] ,'YYYY-MM-DD hh:mm:ss[.fffffff]')))</P><P>Desta forma irá subtrair todas as horas do seu campo data hora</P><P>Mas se precisar definir quantas horas subtrair, tente:</P><P>Timestamp( Timestamp#([SEU_CAMPO_DATA_HORA,'YYYY-MM-DD hh:mm:ss[.fffffff]') - 1/24 )</P><P>Obs.: 1/24 = 1 hora</P><P>Abraços e sucesso.</P> Fri, 11 Oct 2019 13:49:45 GMT https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1634297#M57909 mario_sergio_ti 2019-10-11T13:49:45Z https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1634430#M57919 Não entendi bem, você quer <BR />a) subtrair horas de uma data? Se for é CampoData - 5/24 (subtraindo 5 horas)<BR />b) se quiser separar as horas de um campo data/hora use um Time(Frac(CampoDataHora)) Fri, 11 Oct 2019 18:50:27 GMT https://community.qlik.com/t5/Brasil/subtrair-horas/m-p/1634430#M57919 Clever_Anjos 2019-10-11T18:50:27Z