time format with function

  • Thread starter Thread starter sconner
  • Start date Start date
S

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?
 
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
 
Back
Top