time format with function

[sconner]

I am trying to concateneate the following record using the
function =CONCATENATE(C2," ",D2)
9/22/2004 4:00 PM Cross Country @ Higley
0.666666666666667 Cross Country @ Higley
As you can see, 4:00PM is coming through as a decimal.
If I format C2 to date is shows 4:00pm but E2 is 0.66
C2 as text it becomes 0.66 in c2
c2 as custom date, it reverts to date.

How can I concatenate the time?

 

[Frank Kabel]

Hi
try
=TEXT(C2,"MM/DD/YYYY hh:mm") & " " & D2

 

[Max]

If you have:

in C2: 9/22/2004 4:00 PM
(C2 custom formatted as "m/dd/yy h:mm AM/PM")

in D2: Cross Country @ Higley

and you put in E2:
=TEXT(C2,"m/dd/yy h:mm AM/PM")&" "&TRIM(D2)

E2 will return:
9/22/2004 4:00 PM Cross Country @ Higley

Using "&" is equivalent to using CONCATENATE()
except much shorter to type