Trying to concatenate date and time

emmabe

New Member
Joined
Jul 14, 2009
Messages
33
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?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try like this

=A1+B1

If necessary custom format as Date & Time.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,017
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top