You can try a few things:
enter '=now()' into your cell and format as 'm/d/yyyy h:mm'

If you want to calculate a short difference in time, such a certain number
of days, try this:
=INT(A2-A1)&"d "&TEXT(MOD((A2-A1),1),"h:mm:ss")

If you want to calculate a short difference in time, such a certain number
of days, try this:
=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"

Regards,
Ryan---

--
RyGuy


"Nathan" wrote:

Hi,

I have two columns. One has a date and the other has the time. I would like
to combine these two points in one cell [date time]. Can anyone tell me how?

Thanks,

Nathan