Se response in worksheet.functions

--

HTH

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


"brianwakin" wrote in message
...
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