Summing a number only once...
 

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

Summing a number only once...
 

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

Summing a number only once...
 

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