combine cells date time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining date and time data 3
separating date and time 5
How do you combine a date field and a time field into one? 6
Concatenate including a date so that the date appears as a date 2
Comparing Excel Dates 5
Excel Sumproduct 0
Merge cells time format 4
subtracting date/time 8

Back
Top