Combine Date and Time column (1 Viewer)

[LadyDi]

I need to combine the date and time column on my spreadsheet, so that I can calculate the number of days that it takes to complete an order. I've tried everything I can think of, but Excel will not allow me to combine these two columns into one. Do you know if this is possible?

I have my date in column M and my time in column N. I would like to combine them so that column O would show both (i.e. 3/17/16 11:32).

These are the formulas I've tried: =M1&N1, =Concatenate(M1,N1), ="'"&M1&"'"&"'"&N1&"'", =Datevalue(M1)&Timevalue(N1). Nothing works. No matter what formula I use, all I get is a number that means nothing to me. I even tried using that number in my calculation and my results come out 10 days off (instead of showing 2 days, it shows 20).

Any assistance you can provide would be greatly appreciated.

 

[JANR]

You don't concaenate date and time, you ADD them together, to get date and time

=M1+N1

Janr

 

[LadyDi]

That worked perfectly. Thank you very much.

 

[Rx_]

Small improvement if needed:
=IF(ISBLANK(C3),"Missing Time",C3+D3)
Where C3 is Date and D3 is time
This can be used to prevent the return of 1/0/1900 0:00
when the cells are blank.
A second IsBlank could be used as a Nested If if only date but no time was submitted.
For an empty cell, just use the double quotes next to each other ""
This can prevent the assumption that the 1/0/1900 was a valid date.