Date & Time merging

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

Guest

I have one column of dates, formated like this: 01/23/04, and a corresponding column of times, formated like this: 10:01 a.m. On each row the date and time go together. I'd like to combine the each date and time set into one cell to look like this: 01/23/04 10:10 a.m
 
Hi
you may use a helper column (lets say column C). Enter the following in
C1:
=A1 + B1
format this cell as date/time and copy down
 
A1: Date
B1: Time

=A1+B1

Reformat the formula cell if desired.

HTH
Jason
Atlanta, GA
-----Original Message-----
I have one column of dates, formated like this: 01/23/04,
Click to expand...
and a corresponding column of times, formated like this:
10:01 a.m. On each row the date and time go together.
I'd like to combine the each date and time set into one
cell to look like this: 01/23/04 10:10 a.m.
 
Back
Top