Single cell with changing results?

This one might be easy for someone with much more experience than I have.

I am trying to keep track of an employee's work hours for the year. I have columns for Week Ending (date), Mon - Fri (separate columns), Total (total hours for the week), Over/Under Week (his hours minus 40), Running Total (a running total of actual hours clocked in), Total Need (number of hours needed through the end of that week), Over/Under Total (running total of hours over or under 40 for each week), then a couple columns that are not important to this question (Vacation, Appointments, etc.).

My goal is to have a single cell that changes at the end of each week (or the end of each day if possible) that shows the number of hours that the employee has worked over or under the required hours for that time period. For instance, if at the end of the second week of 2013 the employee is supposed to have worked 72 hours (32 in week one, 40 in week two) and he works 72.4 (32.1 in week one, 40.3 in week two), the column I created for "Over/Under Week" shows .1 in week one and .3 in week two. The column for "Over/Under Total" shows .4. I have it set up so that if the person works fewer than 40 hours, the "under" appears as a negative number and is added to the previous total (i.e. if the employee works 39.7 hours the third week of this scenario, the "Over/Under Week" would show -.3 and the "Over/Under Total" would show .1 because the -.3 would be added to the .4 from the previous week's total).

The problem with this (even though I can use all the current columns as they are) is that every cell in the "Over/Under Total" column is fully populated for the entire year based on the "Total Needed" (which shows the total number of hours needed by the end of each week) and the "Over/Under Total" column is also fully populated for every week. I'd like a single cell that shows the number of hours over or under at the end of the current week or the end of each day (does that make sense?). The "Over/Under Total" column shows the information, but it would be much more convenient to see it in a single cell that changes at the end of each week (or day).

I can email someone the spreadsheet if needed. I'm using Excel 2000 on Windows XP Pro 64-bit.

This is probably too specific, but maybe someone can help. Thank you in advance...

Lloyd

JBeaucaire,

Did you receive the file?

Lloyd