Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet Formula | Excel Worksheet Functions | |||
Time sheet Formula | Excel Worksheet Functions | |||
Help With Time Sheet Formula | Excel Discussion (Misc queries) | |||
Formula for a time sheet | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) |