C
cmatera
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
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