Merging Two Columns

[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.

 

[David Biddulph]

=A2+B2 and format the result appropriately.

 

[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?

 

[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