Date range lookup/sum?

[MOB]

I have some data that looks like this;

Start Date End Date Hours
1/11/20 2/11/20 20
1/11/20 3/11/20 33
2/11/20 6/11/20 60


What I need is a single formula that can establish that the individual dates hours are as follows;

1/11/20 21 (ie 1/2 of 20, 1/3 of 33)
2/11/20 33 (ie 1/2 of 20, 1/3 of 33, 1/5 of 60)
and so on

I'm not convinced that this is possible with a single formula, and I would need to play with the data first - any ideas?

TIA

 

[MOB]

ok I think I've asked the impossible, so instead, what if I create a grid to the right hand side of the data, a range of dates across the top.

Is there a formula I can use to apportion the hours across the dates grid?

 

[MOB]

This approach worked

=(AND(N6>=$G8,N6<=$H8)*1)*$J8/($H8-$G8+1)