View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Merging Two Columns

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.