ExcelBanter - concatenate function/convert military to AM/PM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - concatenate function/convert military to AM/PM (https://www.excelbanter.com/excel-worksheet-functions/43527-concatenate-function-convert-military-am-pm.html)

brianwakin

concatenate function/convert military 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

David Hepner

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

All times are GMT +1. The time now is 01:58 AM.