Concatenate text and time

[30percent]

Hi,

I tried to concatenate the cell in Day column with cell in Time column so that end the result would be Sunday 23:00. However, the following is what shows.

I use this formula: =CONCATENATE(B3, " ",C3)

Concatenate	Day	Time
Sunday 0.958333333333333	Sunday	23:00

thank you

 

[etaf]

try
=B2&" "&TEXT(C2,"HH:MM")

Book2
	A	B	C
1	Concatenate	Day	Time
2	Sunday 23:00	Sunday	23:00
Sheet1

Cell Formulas
Range	Formula
A2	A2	=B2&" "&TEXT(C2,"HH:MM")