Combine Columns in excel and format

unique12u · Post by **unique12u** » Mon Jun 05, 2006 3:05 pm

I have an excel file with a date column and a time column. I need to have these two be ONE column in yyyy-mm-dd hh:mm:ss format.

If I concatenate the columns Excel does not want to reformat them as a date because it only treats it as text then.

Any suggestions?

Nique

Me_again · Post by **Me_again** » Mon Jun 05, 2006 3:37 pm

If the columns contain a date and time stored in excel's numeric format, what you need to do is add them, not concatenate.

For instance my local date and time are:

6/5/2006 8:23:00

if I format the cells as numbers I see:

38873.00000 0.34931

The date is an integer and the time is a decimal.

Add those numbers and select the display format you want:

38873.349306 = 06:05:06 08:23:00