=text(j4,"hh:mm AM/PM") & " - " & text(k4,"hh:mm AM/PM")

I included the AM/PM in the formatting for the first time.

Tony wrote:

I am using combining two time cells into one cell along with a separator of "
- ".

Source Cell J4 - "11:00 am"
Source Cell K4 - "11:30 am"

Target Cell C4 - "11:00 - 11:30 am"

How do can I do this and get the right formatting? I am currently getting:

0.34375 - 0.688194444444444

--

Dave Peterson