topic Remove time from another time in QlikView https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379766#M494717 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Say I have a field called 'InTime'.</P><P></P><P>A pivot table then has the expression =TIME(InTime,'hh:mm')</P><P></P><P>What would I like is to have this time minus five minutes.</P><P></P><P>Any help would be much appreciated.</P><P></P><P>Regards,</P><P>Jim</P></BODY></HTML> Wed, 22 Aug 2012 09:18:54 GMT 2012-08-22T09:18:54Z Remove time from another time https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379766#M494717 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Say I have a field called 'InTime'.</P><P></P><P>A pivot table then has the expression =TIME(InTime,'hh:mm')</P><P></P><P>What would I like is to have this time minus five minutes.</P><P></P><P>Any help would be much appreciated.</P><P></P><P>Regards,</P><P>Jim</P></BODY></HTML> Wed, 22 Aug 2012 09:18:54 GMT https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379766#M494717 2012-08-22T09:18:54Z Re: Remove time from another time https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379767#M494718 <HTML><HEAD></HEAD><BODY><P>=Time(TIME(InTime,'hh:mm')-Time('00:05','hh:mm'),'hh:mm')</P></BODY></HTML> Wed, 22 Aug 2012 09:25:02 GMT https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379767#M494718 sreenivas 2012-08-22T09:25:02Z Re: Remove time from another time https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379768#M494719 <HTML><HEAD></HEAD><BODY><P>Hello Sreenivas,</P><P>Thank you for this.</P><P>I have not had time to test yet, but should be able to next week.</P><P></P><P>I will let you know how I get on.</P><P></P><P>Regards,</P><P>Jim</P></BODY></HTML> Fri, 24 Aug 2012 09:36:32 GMT https://community.qlik.com/t5/QlikView/Remove-time-from-another-time/m-p/379768#M494719 2012-08-24T09:36:32Z