topic How to add two columns in QlikView https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202770#M60359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have an excel file where I have 4 columns</P><P>RecDate, RecTime, CompDate and CompTime with date and time respectively. I need to concatenate date and time for both parameters and then subs com from Rec to show the difference. Kindly help</P></BODY></HTML> Fri, 26 Nov 2010 07:40:27 GMT 2010-11-26T07:40:27Z How to add two columns https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202770#M60359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have an excel file where I have 4 columns</P><P>RecDate, RecTime, CompDate and CompTime with date and time respectively. I need to concatenate date and time for both parameters and then subs com from Rec to show the difference. Kindly help</P></BODY></HTML> Fri, 26 Nov 2010 07:40:27 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202770#M60359 2010-11-26T07:40:27Z How to add two columns https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202771#M60360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please provide us raw data to understand your issue perfectly</P><P>Regards</P><P>Sunil</P></BODY></HTML> Fri, 26 Nov 2010 07:55:05 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202771#M60360 2010-11-26T07:55:05Z How to add two columns https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202772#M60361 <HTML><HEAD></HEAD><BODY><P>Date of receiving Time of receiving Completion / Filing date Completion Time 11/15/2010 12:28:00 PM 11/16/2010 5:00:00 PM 11/15/2010 8:52:00 AM 11/16/2010 11:24:00 AM 11/12/2010 5:05:00 PM 11/16/2010 10:16:00 AM 11/15/2010 9:11:00 AM 11/16/2010 11:25:00 AM 11/16/2010 9:26:00 AM 11/16/2010 5:33:00 PM 11/15/2010 12:43:00 PM 11/16/2010 5:32:00 PM 11/16/2010 12:33:00 PM 11/16/2010 1:16:00 PM</P></BODY></HTML> Fri, 26 Nov 2010 08:02:16 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202772#M60361 2010-11-26T08:02:16Z How to add two columns https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202773#M60362 <HTML><HEAD></HEAD><BODY><P>Oh, how can I attach a file to this..??</P></BODY></HTML> Fri, 26 Nov 2010 08:02:46 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-columns/m-p/202773#M60362 2010-11-26T08:02:46Z