ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   merge dates and times into one column? (https://www.excelbanter.com/excel-discussion-misc-queries/21815-merge-dates-times-into-one-column.html)

Jack

merge dates and times into one column?
 
I have a list of dates in Col A and a list times in Col B. Is there a way
to merge the dates and times into one column?

Jack



Jason Morin

Just add them. =A1+B1

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a list of dates in Col A and a list times in Col

B. Is there a way
to merge the dates and times into one column?

Jack


.


Jack

Jason,

Concatenate didn't do it, but that does it -- now why didn't I think of
that?!

Thanks.

Jack


"Jason Morin" wrote in message
...
Just add them. =A1+B1

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a list of dates in Col A and a list times in Col

B. Is there a way
to merge the dates and times into one column?

Jack


.





All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com