Hi Brad,

just use a1+b1 (assuming 5/11/2006 is on a1 and 11:00 am in b1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



" escreveu:

On a labor time spreadsheet, The date is in one cell and the time is
shown in successive cells for each record.

I need to be able to merge the date (5/11/2006) and the time (11:00 am)
in order to get (5/11/2006 11:00 am).

Concatenate isn't helping.