I want to concatenate one cell with a date with one cell with a time and assign the value to a third cell.

[ScottInTexas]

I just want to concatenate 7:05 (Range("a21") to 6/3/2020 Range("a22") and stuff it in Range("J1"). I guess I forgot how because I keep getting "6/3/2020 0.329861111111111" in Range("j1"). I tired formatting with

Range("Completed").value = Format(Range("a21").value & " " & Range("a22").value, "MM/dd/yyyy HH:mm")

doesn't work. Setting the cells value type, i.e. to Time, doesn't work either. Just concatenating the two and putting it into a Date cell doesn't work.

Thanks for the help.

 

[Fluff]

How about

Range("Completed").value =Range("a21").value + Range("a22").value

 

[ScottInTexas]

That's exactly what did not work, as I said in my OP. I don't want them added. I want them concatenated. in other words it should end up 6/08/2020 7:50 AM.

 

[RoryA]

Do you want the result as text or as an actual date/time value? Fluff's code should give you the latter, so you just need to format the cell to display the way you want.

 

[ScottInTexas]

OK. I tried Fluff's answer again. This time I got a value of four thousand something. I could not get it to format as a date and time . So I closed the workbook. I came back to it a moment ago and ran the same code and it showed up correctly. Don't ask me why.

 

[Fluff]

Glad it's working & thanks for the feedback.