Time to Text

[Toopchi]

Hello. I am trying to concatenate two cells that contain time of the day and show them as a time slot in text format (like: 09:30-11:00). I have changed the destination formats to text and also used the TEXT formula but it returns strange numbers (fraction of 24 hrs I assume). How can I change and specially concatenate time formats into text?
Thanks very much for the support.
Best,

 

[Rick Rothstein]

Assuming your two cells are A1 and B1, I would think this formula should work...

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

 

[Phuoc]

A little shorter

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