HI This is my first post. 

I have a spreadsheet that has the shift times of team members as attached (left side). I am wondering if a formula can be written so it would read the start and finish times and convert it into the format as shown on the right hand side in the box.

Hope I have created this correctly. Thanks very much for your consideration.

Regards

Phil