if formula for time sheet. - help
 

We have 2 week time sheet that calculates each week separatly. (so as to
account for time and a half)
If you use comp time, it will automatically debit the comp time account.
if you work ot - you can get paid, or credit your comp time for it(see week 2)
each week has its own balance.

I have a separate cell for projected comp hours to/from bank.
I am trying to get the formula to recognize that it should carry the 3 over
instead, it returns 2 (-1+3)

here is the formula I was trying
IF(AND(T14<0,T22<0),0),IF(AND(T14<0,
T220),T22),IF(AND(T22<0,T140),T14),IF(AND(T140, T220),T14+T22)

COMP TIME ACCOUNT
CREDIT DEBIT BALANCE
week 1


1



0 1 -1(t14)
Week 2
2





2 0 3(t22)

2(cell to return comp total)
It is probably an easy fix, but I am missing something!
Thank you for your help!

if formula for time sheet. - help
 

Disregard, I figured it out _ Thanks!

"srb911" wrote:

We have 2 week time sheet that calculates each week separatly. (so as to
account for time and a half)
If you use comp time, it will automatically debit the comp time account.
if you work ot - you can get paid, or credit your comp time for it(see week 2)
each week has its own balance.

I have a separate cell for projected comp hours to/from bank.
I am trying to get the formula to recognize that it should carry the 3 over
instead, it returns 2 (-1+3)

here is the formula I was trying
IF(AND(T14<0,T22<0),0),IF(AND(T14<0,
T220),T22),IF(AND(T22<0,T140),T14),IF(AND(T140, T220),T14+T22)

COMP TIME ACCOUNT
CREDIT DEBIT BALANCE
week 1


1



0 1 -1(t14)
Week 2
2





2 0 3(t22)

2(cell to return comp total)
It is probably an easy fix, but I am missing something!
Thank you for your help!