concatenating two times into one cell

[nd2828]

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

[tom1977]

Hi try this
TEXT(A1,"hh:mm") &" - "&TEXT(B1,"HH:mm")

[shekhar1660]

Hi,

try this

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

Shekhar Sharma

[shekhar1660]

sorry Tom, I was late by 1 minute

[tom1977]

Do not be sorry there is no need of this
Have a nice day

[nd2828]

Thanks very much for the quick response, this works great

[shekhar1660]

Hi,

Please mark this post as Resolved, if you don't have any other query regarding the same.