Combining date and time data

  • Thread starter Thread starter Nathan
  • Start date Start date
N

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
 
Just add the two cells together... =A1+A2 assuming the date is in A1 and the
time is in A2.

Rick
 
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---
 
Back
Top