How to add two columns

[#1]

Hi,

I have an excel file where I have 4 columns

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

[#2]

Hi,

Please provide us raw data to understand your issue perfectly

Regards

Sunil

[#3 · Accepted solution]

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

[#4]

Oh, how can I attach a file to this..??