Replicating a custom formatted cell in a concatenated formula! I think!

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

Hi,

May be with this formula:

Please Login or Register  to view this content.

Hope it will help you,

m

thanks mth - nearly worked - just replace the ; with a , and I'm sorted - thanks again!

="Shift 0:00 to "&TEXT(E8,"hh:mm")&" and "&TEXT(F8,"hh:mm")&" to 0:00 at "&A8