I'm trying to create a "Time Sheet" of sorts for people in my department at work. I have a formula that will calculate the amount of time they've worked for the day, based on their start, break and end times. Now I would like a formula that will count their time for the week and if the amount isn't 40 hours, tell them how much time they still need. We can flex our time if need be, and I was trying to make it easy for them to see how much time they would need to make up if they worked a couple days with odd hours. Trying to make things easier is proving to be more difficult than I thought for some reason. Any help?

Thanks!