Concatenate Function/converting military time to AM/PM

B

brianwakin

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"))
 
B

Bob Phillips

Se response in worksheet.functions

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert string to military time string 14
concatenate function/convert military to AM/PM 1
=NOW() Returning military time 5
Concatenate/Text Functions 1
Time Format Issue (Email message body) 4
converts military time into standard AM/PM . 8
Formatting merge field: Military to traditional time 1
Difference in Time hour what formula to use in excel? 4

Top