take numbers from one cell and add to another
 

I am trying to have hrs. worked if less than 80 take from another cell
containing comp time hrs. and increase the the hrs. worked and decrease the
comp time hrs.

take numbers from one cell and add to another
 

You'll have to correct the formulas for the appropraite cells...
Assume:
- Titles are in Row 1
A1: Hrs Worked
B1: Hrs Paid
C1: Comp Hrs Remaining

C2: Beginning Balance - Comp Hrs

A3: # of hours worked
B3: =IF(A3<80,A3+MIN(80-A3,C2),A3)
C3: =+C2+IF(A3<80,A3-B3,0)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"jst4tdy" wrote:

I am trying to have hrs. worked if less than 80 take from another cell
containing comp time hrs. and increase the the hrs. worked and decrease the
comp time hrs.