Distribute Value by Hour

How can one distribute a cell value (A2) over the course of a number of hours (B2) using the inputs in column D of the attached? I provided an expected result but keep in mind that the cells in yellow need to be adjustable and I used 4 hrs in the example because the math is very simple to calculate. My issue is creating a formula that can work with the adjustable input cells and distribute the value in A2 by any given number of hours entered in B2 between 0 and 6.9.

I have been trying for hours on this even though it may seem simple to some...I would REALLY appreciate any help...and let me know if I can make this explanation any clearer.

Thanks,

D

Can I clarify anything? No luck? I ask because this seems very possible...

Hello dreicer_Jarr

See the attached, I revised the layout very slightly so that E2:E4 contains the percentages 25%, 50%, 25% and there are two "helper" columns in F1:F4 and G1:G4 (you can hide these if you want), then in B7 this formula copied down

=MIN(1,LOOKUP(A7,F$1:F$3,G$1:G$3+(A7-F$1:F$3)*D$2:D$4/(E$2:E$4*B$2)))*A$2-SUM(B$6:B6)

See attached

It's possible to eliminate the helper columns if you want but it will make the column B formula more complex......

regards, daddylonglegs