Calculate the number of minutes in each hour of breakdown

Hi,
I am trying to calculate the the breakdown time for each hour in the factory. I have the start time and finish time of each breakdown. There are 8 hours in a shift starting at 6:45. So hour 1 would be (6:45-7:45), hour 2 (7:45-8:45). If the machine breaks down between 7:06 and 8:20 what will be the amount of time lost in each hour? In this example it would be 39 mins in hour 1 and 35 mins in hours 2.
Can some help as to how I can acheive this result?

Regards,
Tim

Hi,
Thanks for your help. Can you send me the spreadsheet? When I do this calculatiuon it gives me a decimalised result.I need the result in minutes.

Regards, Tim

Hi,
Thanks. Looking at the spreadsheet it doesn't give the result I need. I need the breakdown minutes for each hour so hour 1 should be 39mins and hour 2 should be 35mins.

The result on your spreadsheet is incorrect as there are 74minutes between 7:06 and 8:20 not 64?

Regards, Tim