Hi - I have a cell which has a time in it hh:mm format

I want the time to appear on another line but amongst other data (in different formats) which has been concatenated

Hope the attachment works

Hope you can help

Thanks as always - Paul

Excel Forum - Hours Value.xlsx