Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add two columns

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

Hi,

Please provide us raw data to understand your issue perfectly

Regards

Sunil

Not applicable
Author

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

Not applicable
Author

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