Rota in Excel - Formula for creating daily overview based on shifts times

Hi Ali

Many thanks for the prompt response.

I have slimmed down the attached rota to show a 2 week block on the first tab with 20 staff on it. On the second tab is the format I would like the daily sheet to appear, columns are headed with the shift time and then the name of that person/s working that particular shift. I am only looking for those particular shift times as headed on tab 2, other information you will see such as "OFF", "H" or "R#" can be ignored.

As requested on tab 2 I have created a mock up for 06/05/19.

I look forward to response, and thanks again for your help.

Jamie (pokerjam)