Progressive calculation based on date and months

RE attached file.
I would like any hours (Column K) with an “ST” result (Column G) to recalculate on the following criteria.

Based on the current month/date:
The hours in column K need to be divided by the number of month’s “From” and “To” columns D and E.
Then multiplied by the months that have passed.

Example is Row 4.
Months are “From” January “To” May which is a total of 5 months.
The total hours are 20.
The formula needs to divide the hours by 5 months, which equals 4 hours per month.
The current month is February, which means my adjusted hours (column N) should show 8. This is 4 for January and 4 for February.

At line 11, 80 hours, divided by 8 months equals 10 hours per month.
Current month is February, so the adjusted hours should be 20 hours.

The current date can be inserted at Reference O2.
Data in the report will change from month to month and needs to be updated on an ongoing basis.
I hope someone can help me out here.
Thanks in anticipation
Chris

As per usual - a promt response with a correct outcome.
Rylo - brilliant as usual. Thanks Heaps.

Found a glitch - if you change result in first line to ST, it provides me with a total of 40.
this is incorrect. The multiplier is x 5 (as May is the 5th month), but it should only count the month as 1, because the start month and end month are the same = 1.

The hours allocated is a maximum, but is divided by the number of months it covers from start to finish.

I hope this expanation is clear enough.

Hey Rylo

Its all about payment really, one would anticipate no ST results would appear before a starting date.
They should appear either on or just after, however they may not change for any period of time after that.

Based on 20 hours as an example.
The concept is - payments are based on an ST to start it off, which is based on the number of months between the start and end dates, so:

Example 1
If it is one month (February start and end dates)
then calculation would be hours/months*per month (20/1*1=20) but always only to the maximum total.

Example 2
If start and end dates (20 hours) are over 2 months - say Feb and March,
then we have hours/months*per month
In February it would be 20/two months*one month = 10
In March it would be 20/two months*2 months = 20

Example 3
For a unit of 90 hours with start and end dates covering Apr, May, June
in April it would be 30,
May it would be 60 and
in June it would total out 90

I hope this makes the query clearer.
regards