View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_928_] Rick Rothstein \(MVP - VB\)[_928_] is offline
external usenet poster
 
Posts: 1
Default 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