Merging Two Columns

A

abs

Using Excel 2003. Column A is a date and Column B is a time. I need the two
columns merged into Column C. Thank you.
 
W

woalmoore

By "merge" do you mean you need the strings concantenated?...i.e. 3/12/08 in
Column A and 3:46 in column B becomes 3/12/08 3:46?
 
F

FSt1

hi
if a is a date and b is a time then both are just numbers formated as data
and time.
a simple formula will combine them.
= a1+b2

regards
FSt1
 
Top