Merge cells time format

[Arne Hegefors]

Hi! In column A I have dates eg 2008-05-06. The format of the cells is date
also (excel sees the column as proper dates). In column B I have time eg
11:43:10. The format of those cells is time (excel also sees them as proper
time stamps). Now I want to combine the values in column A with column B. The
result is supposed to be a date and a time stamp in the same cell eg
2008-05-06 11:43:10. I tried simply to merge A and B in column C by writing:
=A1&" "B18 (i have tried without the blank space also). But I cannot get
Excel to understand that they are date and times ie the format is not working
properly in column C. what can I do to fix it? I tried to copy the results
and then paste special (pasting only the values) and then chnaging format.
any help appreciated!

 

[Jarek Kujawa]

=TEXT(A1,"yyyy-mm-dd")&" "&TEXT(B1,"hh:mm:ss")

 

[David Biddulph]

Simply =A1+B1, and format the result as yyyy-mm-dd hh:mm:ss

 

[David Biddulph]

The OP (whose question you snipped) didn't want text, but wanted an Excel
date and time.
He needs =A1+B1, appropriately formatted.

 

[Jarek Kujawa]

exactly, didn't think of it
thks David