ExcelBanter - combine cells date time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - combine cells date time (https://www.excelbanter.com/excel-worksheet-functions/114884-combine-cells-date-time.html)

combine cells date time

Does anyone know how to combine dates and times that are in two different
columns into one column!? I know that dates and times are really just a
series of numbers and when I use the CONCATENATE function it does add those
values together but I'm stumped as to how to get the column to show the date
and time separately. I've got over 100K lines of data so a shortcut would
really help

combine cells date time

Not sure what you're asking, but:

A1 = 10/17/2006
B1 = 10:00 PM

=A1+B1

Choose one of the formats you like.

Biff

"Stumped" wrote in message
...
Does anyone know how to combine dates and times that are in two different
columns into one column!? I know that dates and times are really just a
series of numbers and when I use the CONCATENATE function it does add
those
values together but I'm stumped as to how to get the column to show the
date
and time separately. I've got over 100K lines of data so a shortcut would
really help