CONCATENATING DATE AND TIME
 

How can I combine two columns to one new column
Example: (i'm trying to find "C")

A B C
[Date] [Time] [Both]
01/01/2005 14:45:00 01/01/2005 14:45:00

I need column "C" to be a format as mm/dd/yyy hh:mm:ss

I tried Concatenaing("A1", "B1") but I get a bunch of numbers

can anyone help?

CONCATENATING DATE AND TIME
 

What do you consider a "real answer"?

Gary''s Student's answer is appropriate and, if you implement it properly,
should do what you specify.

What, exactly, happened when you tried his recommendation?



On Wed, 9 Nov 2005 16:29:42 -0800, bladelock
wrote:

Does some have a real answer to this, please

"Gary''s Student" wrote:

Try just adding them. Example:

1/12/2005 7:30 AM 1/12/2005 7:30
in cols A,B,C
--
Gary''s Student


"bladelock" wrote:

How can I combine two columns to one new column
Example: (i'm trying to find "C")

A B C
[Date] [Time] [Both]
01/01/2005 14:45:00 01/01/2005 14:45:00

I need column "C" to be a format as mm/dd/yyy hh:mm:ss

I tried Concatenaing("A1", "B1") but I get a bunch of numbers

can anyone help?

--ron