# Concatenate Function/converting military time to AM/PM

1. ## 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

2. ## Re: Concatenate Function/converting military time to AM/PM

Se response in worksheet.functions

--

HTH

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

"brianwakin" <brianwakin@discussions.microsoft.com> wrote in message
news:0FAEDCDD-BE8B-4ACB-B36C-BD0BD2C35440@microsoft.com...
> 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

3. ## Re: Concatenate Function/converting military time to AM/PM

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

--
Regards,
Tom Ogilvy

"brianwakin" <brianwakin@discussions.microsoft.com> wrote in message
news:0FAEDCDD-BE8B-4ACB-B36C-BD0BD2C35440@microsoft.com...
> 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1