Date and time manipulation

Hello,

Nice to be here. I am looking for assistance with the following.

There are two date sections - MDY column and a TIME row. Instead, I would like there to be only a single date and time column.

I would like to ask, If anyone can please tell me how to automate such conversion/transformation.

Please see the screenshot below, it should depict what I would like to achieve.

Thank you!

WS.png

Hi AlexMK,
maybe so

Please Login or Register  to view this content.

By almost I mean that dates did not include the time

if your example is according to the screenshot, then clean the cell A1, and try to run macro again.

Thank you nilem for looking at this once again!

When I clear the cell A1, Excel gives the following error:

Run-time error '13':
Type mismatch

And debugger higlights/stops at this line: "y(k, 1) = x(i, 1) + x(1, j)"

Hi AlexMK,
Could you please attach an example of your file

Good morning nilem!

Forum attachment function button does not work for me properly, so please download the file here:

http://dropcanvas.com/g1d1l

I would have provided a link to file from the beginning, but I thought that it might not be proper to do this for a newcomer to forum, as files from unknown people (like me), especially files that can contain macros, can have malicious code and what not.

Thank you once again!

Alex,
here is your file, try again

The code in the attached file performs without issues on my system.

Thank you very much nilem for your generosity—the time and effort that you put into this request! This is truly a wonderful forum :-)