topic Re: Subtracting Number and Time in QlikView https://community.qlik.com/t5/QlikView/Subtracting-Number-and-Time/m-p/1147194#M891458 <HTML><HEAD></HEAD><BODY><P>Not sure what you are looking to get, but try this:</P><P></P><P><STRONG>=(Sum(totalhrs)*24)-((vWorkDay - (CL-OD))*8.5)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135160_Capture.PNG" style="height: 254px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 22 Aug 2016 10:45:13 GMT sunny_talwar 2016-08-22T10:45:13Z Subtracting Number and Time https://community.qlik.com/t5/QlikView/Subtracting-Number-and-Time/m-p/1147193#M891457 <HTML><HEAD></HEAD><BODY><P>I am facing an issue lik I have actual hrs that is in Number format and clocked hrs that is in hrs format but i need to subtract them I have attached qvw file</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subtracting-Number-and-Time/m-p/1147193#M891457 gautik92 2020-11-25T16:16:04Z Re: Subtracting Number and Time https://community.qlik.com/t5/QlikView/Subtracting-Number-and-Time/m-p/1147194#M891458 <HTML><HEAD></HEAD><BODY><P>Not sure what you are looking to get, but try this:</P><P></P><P><STRONG>=(Sum(totalhrs)*24)-((vWorkDay - (CL-OD))*8.5)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135160_Capture.PNG" style="height: 254px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 22 Aug 2016 10:45:13 GMT https://community.qlik.com/t5/QlikView/Subtracting-Number-and-Time/m-p/1147194#M891458 sunny_talwar 2016-08-22T10:45:13Z