How to count the hours spent each hour when start/end time spans over more than one time category

[antmichaelides96]

Hi,

I'm wanting to be able to create some summaries based on existing data.

In Column A is the start time of an activity E.g 10:00
and Column B is the end time E.g 12:30.

I'm wanting to create summaries by hour to show much time is spent each hour. For example, the above case would count one hour for 10-11, one hour for 11-12 and half an hour between 12-1.

Any ideas on how to do this would be much appreciated!