View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default date time consolidation

It's as simple as adding them together: a1+a2
Format as desired.

Regards,
Fred

"Andrew" wrote in message
...
I have two separate cells. One with data one with time. I need to make
the
two cells into one with the date and time. Seems simple but.....