Help with a formula for a Time Sheet.

[SarahAshlee]

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

Thanks

 

[Stan Brown]

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?

This sounds like a homework assignment, but:

If the hours worked in the week are in B1, your formula is
=MAX(40-B1,0)