Need correct format of date/time after joining a separate date and time cell together???

[jandtng]

When I textjoin a date cell and a time cell, I do not get the right time display. It shows a fraction as the time. I tried to use format but can't find a way to convert it back to military time. Can someone help? TIA

 

[rlv01]

Instead of Textjoin (which is for text, not dates), use addition.

Book1
	A	B	C	D
1	3/14/2024	18:40	3/14/2024 18:40
2
Sheet1

Cell Formulas
Range	Formula
C1	C1	=A1+B1

 

[jandtng]

Instead of Textjoin (which is for text, not dates), use addition.

Book1
	A	B	C	D
1	3/14/2024	18:40	3/14/2024 18:40
2
Sheet1

Cell Formulas
Range	Formula
C1	C1	=A1+B1

Thanks rlv01, that worked