How to calculate hours between 2 times.....

[graf4014]

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.

[graf4014]

Any advise??Any tips??

Again, I'm trying to figure out a formula:

IE

Preferred Hours Monday: 8am to 12pm

My schedule for Monday: 10am to 6pm

How many hours out of Preferred hours did I work?: 2 hours

(NEED A FORMULA FOR THIS)

THANK YOU EXCEL WIZARDS!

[BoardGuy]

If you could post a worksheet outlining what you are trying to do, perhaps a visual example will help others understand what you are trying to do.

[graf4014]

I attached the sample.

Thank you

[graf4014]

This was Solved by an outside source.