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.

=A2+B2 and format the result appropriately.
--
David Biddulph

"abs" wrote in message
...
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.

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?

"abs" wrote:

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.

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

"abs" wrote:

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.