Hi

I am trying to concatenate 2 cells that have start and finish times in, and put both times into one cell seperated by -

example:
Column Headings
A1: Start Time
B1: Finish Time
C1: Shift

Data
A1: 08:00 ([h]:mm format)
B1: 16:00 ([h]:mm format)
C1: 08:00 - 16:00

I have tried =Concatenate(A1, " - ", B1) it does it but turns the time into decimal.

Please can someone help

Thanks