Concatenate Date and Time - Issue with Formatting

I'm trying to concatenate two cells - the first with the date and the second with the time. When I concatenate, however, instead of showing as 10/28/16 11:57 AM it returns a value of 42671 0.497916666666667.

I've tried everything but can't seem to get it to format correctly.

Welcome to the board.

Don't use concatenate, just use plain math.

=A1+B1

A1 = Date
B1 = Time

Thank you so much, Jonmo1! Worked like a charm.

You're welcome.

One more quick question if you guys don't mind.

I took the Order Release Date of 3/10/187 1:32 PM minus the Order Received Date of 2/16/17 2:24 PM to create the Time to Release of 0:06:03 (6 minutes and 3 seconds). How do I add a column to report orders released within 1 hour, 2 hours, 24 hours, 48 hours and over 48 hours?

Assuming cell C2 has this Time to Release value.
Try
=IF(C2>2,"Over 48",IF(C2>1,"Within 48",IF(C2>"2:00:00"+0,"Within 24",IF(C2>"1:00:00"+0,"Within 2","Within 1"))))

Beautiful! I was trying to do a lookup, but figured there had to be an easier way. Thank you!

Actually, lookup would be the easier way.

Just need a numeric representation of "1:00:00" and "2:00:00"

1:00:00 = 1 hour, 1 24th of a day, 1/24, 1 devided by 24 = 0.041667
2:00:00 = 2 hours, 2 24th of a day, 2/24, 2 devided by 24 = 0.83333

We can use those 2 numbers in our lookup table along with 0 1 and 2

=LOOKUP(C2,{0, 0.041667, 0.83333, 1, 2},{"Within 1", "Within2", "Within 24", "Within 48", "Over 48"})