I have created a pivot table that lists employees ("Resources") down the rows, and each column is a calculation of how much project work they've been assigned to in a given week. (The underlying table lists resources in individual projects, the pivot is to "roll up" the totals).

What I'd like to do is:

Under each row (i.e., under each Resource), demonstrate how much REMAINING time in a work week they have. Essentially, it would be "=40-[cell above]".

So what I have is:
RESOURCE | WEEK ONE | WEEK TWO | WEEK THREE |
rjbinney | 12.5 | 27.1 | 18.5 | 10.5
alincoln | 10.0 | 15.0 | 10.0 | 5.0

What I'd like is:
RESOURCE | WEEK ONE | WEEK TWO | WEEK THREE |
rjbinney | 12.5 | 27.1 | 18.5 | 10.5
| 27.5 | 12.9 | 22.5 | 29.5

alincoln | 10.0 | 15.0 | 10.0 | 5.0
| 30.0 | 25.0 | 30.0 | 35.0
Any advice would be appreciated.

rjb