To make it short and sweet I'm trying to make a schedule that allows me to do two things: Add up to 40 hours and count specific hours out of the 40 worked. Below is a rough idea of what I'm talking about.



Preferred hours

Sunday Monday Tuesday Wednesday Thursday Friday Saturday EXAMPLE
12p to 9p 8a to 10p 5p to 10p 5p to 10p 5p to 10p 8a to 12p 8a to 5p
5p to 9p



My Schedule

11-May 12-May 13-May 14-May 15-May 16-May 17-May
Saturday Sunday Monday Tuesday Wednesday Thursday Friday TOTAL
7 to 2:30 11 to 8 3 to 9 3 to 9 3 to 9 3 to 9 off 40 hours


So out of this schedule above.. I need to come up with a way to figure out how many hours fall under the "preferred hours" list. IE Saturday may 11th there were 6.5 preferred hours worked out of a possible 7.5 hours.

PLEASE HELP!!!! I can't figure out the formula for this.

Thanks,
Andy

PS I need to make sure people are scheduling themselves for at least 30 preferred hours a week...I'm sick of adding them up.