Try this:

=CONCATENATE(TEXT(B7,"h:mm AM/PM")," - ",TEXT(C7,"h:mm AM/PM"))


"brianwakin" wrote:

I wrote the formula below to display time that was originally in two separate
cells into one cell separated by a " - ". It works accept the result is
displayed in military time and not in AM/PM. Any help would be appreciated.

=CONCATENATE(TEXT(B7,"h:mm")," - ",TEXT(C7,"h:mm"))


--
Brian