Trying to concatenate date and time

[emmabe]

I have two cells in Excel 2010.

One contains a serial number which converts to the short date format "1/31/2011"

The second cell contains time "10:42:00 PM"

What I want to have is a cell which reads:

"1/31/2011 10:42:00 PM"

that I can use to calculate time intervals.

Concatenating the two cells yields a decimal which can't be displayed as a date.

I've tried googling how to do this but I can't seem to get the right key words ... any suggestions how I get this formula to work?

 

[VoG]

Try like this

=A1+B1

If necessary custom format as Date & Time.

 

[emmabe]

Try like this

=A1+B1

If necessary custom format as Date & Time.

Clearly I needed more coffee this morning...

Thank you.