Thanks for the fast reply.

I may not have explained this quite correctly.

I've attached another file to show a better idea of the output table I needed.
The difference is that I need it to be set intervals as column fields, each 15 minutes through the day.
examplereult.xls