Expand a simple report into 15 minute slots for deeper analysis

[C J W]

Hi

Please see the attached document, with sample data entered onto it. The report sheet states that a person will be on a set activity between two times and then the next etc. I would like to be able to break this down into 15 minute slots on the analysis page for each person on the report. I have attached a copy of the basic outline of the template. For the purpose of the report I have listed 4 activity types but this will potentially reach about 30-40.

Thanks