I wish to make a time slot

Hi Guys,

I would like to create a time slot, based upon two separate cells, I wish to merge these cells.
e.g.
A1: 09:00 AM
A2: 10:00 AM
i wish to merge cells A1 and A2 into A3 to get
A3: 09:00-10:00

Is there a formula or function within excel 2010 to do this?

Thanks in advance.

If those are proper times, then you can use this in A3:

=TEXT(A1,"hh:mm") &"-"& TEXT(A2,"hh:mm")

If the cells contain text values which happen to look like time values, then you can use this:

=LEFT(A1,5) &"-"& LEFT(A2,5)

Hope this helps.

Pete

Thank you Pete_UK, this has resolved my problem.

My data was in the time format.

I tried to use concatenate, but I could not anywhere near what I needed.

Many thanks,

Glad to be able to help, and thanks for the rep.

A straight concatenate would have given you some strange fractional numbers, which is how Excel stores times internally, and that is why you have to use the TEXT function.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete