Concatenate Function/converting military time to AM/PM

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

Se response in worksheet.functions

--

HTH

RP
(remove nothere from the email address if mailing direct)


"brianwakin" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
Regards,
Tom Ogilvy

"brianwakin" <[email protected]> wrote in message
news:[email protected]...
> 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