I have start date an end date; need hours per month?

[GoinDeep]

I have a table which records the Start date and End date for various work groups, but now i need to record the total projected hours per month based on a 40hour work week.

This is getting more complex than I anticipated, how can I account for weekends and Holidays?

Thanks in advance for any help!

 

[Autoeng]

Sample located here.

http://www.mvps.org/access/resources/downloads.htm

Autoeng