CONCATENATING DATE AND TIME

B

bladelock

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?
 
R

Ron Rosenfeld

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?



Does some have a real answer to this, please

Gary''s Student said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...

--ron
 
Top