Merge cells time format
 

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!

Merge cells time format
 

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

Merge cells time format
 

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

"Arne Hegefors" wrote in message
...
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!

Merge cells time format
 

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

"Jarek Kujawa" wrote in message
...
=TEXT(A1,"yyyy-mm-dd")&" "&TEXT(B1,"hh:mm:ss")

Merge cells time format
 

exactly, didn't think of it
thks David