I have a 14 day pay period where I am trying to calculate the balance
of time at which a person is "off pay"

After 14 days I want to show the total amount of time a person is off
pay. So for example -

From 8/23 - 9/5/08
I have a person who is off pay for 8 hours (-8) the first week and
then another 6 hours (-6 hours) the second week. I want to total up
the amount of time this person is off pay (-14)

The problem I'm running into is as follows:
Each day has a balance cell. So if a person is off pay 8 hours the
balance cell is populated with that -8 However I only want to
calculate this once

I'd be glad to clarify some more if people need...any help is greatly
appreciated.

Thanks

Sorry here's more details -

I want the sum to appear in a cell (K57)

I have my dates on cells I5-AV5

The cells that I want summed are in J57-M57-P57 all the way to AW57

As I said if someone is off pay for 8 hours...each of the balance
cells gets populated with -8 (until the end of the week)
Then if they are off pay for another 6 hours the next weeks balance
cells will get populated with -6

I want K57 to display the total ammount off pay -8 + -6 = -14

On Sep 11, 4:19*pm, cmatera wrote:
I have a 14 day pay period where I am trying to calculate the balance
of time at which a person is "off pay"

After 14 days I want to show the total amount of time a person is off
pay. *So for example -

From 8/23 - 9/5/08
I have a person who is off pay for 8 hours (-8) the first week and
then another 6 hours (-6 hours) the second week. *I want to total up
the amount of time this person is off pay (-14)

The problem I'm running into is as follows:
Each day has a balance cell. *So if a person is off pay 8 hours the
balance cell is populated with that -8 *However I only want to
calculate this once

I'd be glad to clarify some more if people need...any help is greatly
appreciated.

Thanks

See responses to your earlier post on same subject.

Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 13:23:31 -0700 (PDT), cmatera wrote:

Sorry here's more details -

I want the sum to appear in a cell (K57)

I have my dates on cells I5-AV5

The cells that I want summed are in J57-M57-P57 all the way to AW57

As I said if someone is off pay for 8 hours...each of the balance
cells gets populated with -8 (until the end of the week)
Then if they are off pay for another 6 hours the next weeks balance
cells will get populated with -6

I want K57 to display the total ammount off pay -8 + -6 = -14

On Sep 11, 4:19*pm, cmatera wrote:
I have a 14 day pay period where I am trying to calculate the balance
of time at which a person is "off pay"

After 14 days I want to show the total amount of time a person is off
pay. *So for example -

From 8/23 - 9/5/08
I have a person who is off pay for 8 hours (-8) the first week and
then another 6 hours (-6 hours) the second week. *I want to total up
the amount of time this person is off pay (-14)

The problem I'm running into is as follows:
Each day has a balance cell. *So if a person is off pay 8 hours the
balance cell is populated with that -8 *However I only want to
calculate this once

I'd be glad to clarify some more if people need...any help is greatly
appreciated.

Thanks