Combining date and time data
 

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

Combining date and time data
 

C1=A1+B1
--
Gary''s Student - gsnu200795


"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

Combining date and time data
 

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

Rick


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

Combining date and time data
 

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