View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Difficulty merging a Date and Time

Just add them together and choose an appropriate format:

=A1+B1

Hope this helps.

Pete

On Apr 30, 5:06 pm, Adam wrote:
I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?