Formatting for two times in one cell?

[ScousePete]

I have a sheet that contains start times in column A and end times in column B.

I have another sheet that I would like to pull the start time and end time into one cell for ease of printing.

Like this -

8:00AM - 5:00PM

When I use the following formula -

=sheet1!A1&" - "&sheet1!B1

it pulls the data over, but changes the format to two numbers. I've tried all the usual formatting, but to no avail.

 

[Fluff]

How about
TEXT(Sheet1!A1,"hh:mm am/pm")&" - "&TEXT(Sheet1!B1,"hh:mm am/pm")

 

[shg]

=TEXT(Sheet1!A1, "h:mm AM/PM - ") & TEXT(Sheet1!B1, "h:mm AM/PM")

 

[ScousePete]

Perfect! You guys rock, thank you!!

 

[Rick Rothstein]

Perfect! You guys rock, thank you!!

You showed your time values without the space in front of the AM and PM in your original post... if you would still want that, then use this modification of shg's formula instead...

=TEXT(Sheet1!A1, "h:mmAM/PM - ") & TEXT(Sheet1!B1, "h:mmAM/PM")

 

[Fluff]

Glad we could help & thanks for the feedback