Concatenate with mixed cell formats

S

Stead

I am trying to concatenate four fields, two are text but two are times
The problem lies in the fact that as soon as the times are added th
cell returns the value #VALUE. I cannot change the format of the time
because 09:00 becomes something like 0.625. Help if you have an
solutions.

Thanks in advance, Paul
 
J

Jason Morin

If A1 and C1 contain text and B1 and D1 contain your time
values, then try:

=A1&" "&TEXT(B1,"h:mm AM/PM")&" "&C1&" "&TEXT(D1,"h:mm
AM/PM")

HTH
Jason
Atlanta, GA
 
Top