Subtract frim a static total
 

Its kind of hard to put into words what i need, but its basically a time
balance sheet for payroll. I have a cell with a static value, say 49 hours. I
want it to show the 49 hours for a regular work week if no special leave time
is taken in that week. For example, lets say a day off of 8 hours was taken,
I want that calculated and subtracted and instead of 49 displayed, 41 is
there instead.

I have 4 seperate weeks of this, without going into a longer explanation.
But here is an example of what my cells look like.
Cells C9-H9 (if all are blank, then,) I9=49.00 (if C9-H9 have a value, then
subtract it from the static 49.00hrs in I9.
Again, there is 4 weeks of this same thing. c9-h9 represents the first week
and the next 3 weeks are directly under those, including i9-i12 that have my
static work totals.
Hope this is enough info to start to see what i need..
Thanks :)

Subtract frim a static total
 

Since Excel treats blanks as zeroes in calculations you can simply use this
in I9
=49 - Sum(C9:H9)
and copy down to get it for other weeks...

or
=49 - SUMIF(C9:H9,"0")

"DayzM" wrote:

Its kind of hard to put into words what i need, but its basically a time
balance sheet for payroll. I have a cell with a static value, say 49 hours. I
want it to show the 49 hours for a regular work week if no special leave time
is taken in that week. For example, lets say a day off of 8 hours was taken,
I want that calculated and subtracted and instead of 49 displayed, 41 is
there instead.

I have 4 seperate weeks of this, without going into a longer explanation.
But here is an example of what my cells look like.
Cells C9-H9 (if all are blank, then,) I9=49.00 (if C9-H9 have a value, then
subtract it from the static 49.00hrs in I9.
Again, there is 4 weeks of this same thing. c9-h9 represents the first week
and the next 3 weeks are directly under those, including i9-i12 that have my
static work totals.
Hope this is enough info to start to see what i need..
Thanks :)

Subtract frim a static total
 

That worked perfectly, thanks :)