Dates Forecasting Logic

[Skien]

I'm trying to figure out if there's a way to do this in Access. Here's my
dilemma...
I have multiple start and finish dates, trying to figure out how many hours
resource A is planned to work each month based on the data given, and place
those plan hours in the correct month, starting from Jan thru Dec. Any ideas
on the logic to do this in Access is appreciated.

For example:
Data
Resourc Start Date Finish Date PlanHours

A 24-Dec-07 29-Feb-08 55
A 24-Dec-07 29-May-08 10
A 01-Jan-08 31-Dec-08 40
Output
Resource JanPlan FebPlan MarPlan AprPan etc.......
A 33 33 6 6

 

[KARL DEWEY]

The hours value you placed in the months defeys logic. How do you arrive at
those numbers?

 

[Skien]

Here's my logic:
First Line: 2 working months: Jan = 27.5 hours, Feb = 27.5 hours
Second Line: 5 working months: Jan =2 hours, Feb=2 hours, Mar=2 hours,
April=2 hours, May=2 hours
Third Line: 12 working months: Jan=3.3 hours, Feb=3.3 hours, Mar=3.3 hours,
Apri=3.3, May=3.3, Jun=3.3, Jul=3.3, Aug=3.3, Sept =3.3, Oct=3.3, Nov=3.3,
Dec=3.3

Jan hours=27.5 hours + 2 hours + 3.3 hours =32.8 hours
Feb hours=27.5 hours + 2 hours + 3.3 hours =32.8 hours
Mar hours=2 hours + 3.3 hours =5.3 hours
Apr hours =2 hours + 3.3 hours = 5.3 hours

Sorry, my initial calculations wasn't very accurate.
Thanks.

 

[KARL DEWEY]

Next question - what part of a month does not count as a month as your 24 Dec
start does not include Dec in output of plan spread?

Is it any part of month less than half on either end?