Combining date and time into one cell

K

Kelly C

I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.
 
M

Myrna Larson

Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
describe.
 
B

Bob Phillips

=TEXT(A1,"m/dd/yy ")&TEXT(B1,"hh:mm")

is one way

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
L

lisa

Myrna - I found your solution very helpful! Much better than the combining
text. It maintained the format and I was able to perform other functions on
the result.
Thank you!
 
Top