Combining date and time data

[Nathan]

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

 

[Gary''s Student]

C1=A1+B1

 

[Rick Rothstein \(MVP - VB\)]

Just add the two cells together... =A1+A2 assuming the date is in A1 and the
time is in A2.

Rick

 

[ryguy7272]

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