First post here after driving myself mad trying to find a workable solution to this. I have tried to give as much information as possible in the hopes that somebody can help please!

I am trying to create a timeline based on a table as per the image.

I want the output to look like the right hand diagram but in 5 minute increments to reduce the size of the list as this will run 6am-6am. It will be about 10k rows of data so this is just a snap shot.It will all be on the same worksheet.

• The table
  The columns will always be in the same place. The time is “HH:MM” format. The person name will always be unique.

• The output
  The header row will always be the same.
  The times should be in increments of 5 minutes so if the time falls between the row time and the time above it then add which player it is.
  The player should be highlighted in yellow with the cell above being blue.

I have used formulas to get the information in the diagram but with it being so data hungry i suspect it will either crash excel or take 3 weeks to run. Is there a VBA equivalent to this.
=IFERROR(INDEX($B:$B,MATCH(G$1&$F2,$C:$C&$A:$A,0)),””)

enter image description here