Format IF formula for comp time

[rblanchard78]

I am working on creating a comp time tracking sheet for our employees and need a formula for one of the cells.


=IF(AC17>AC24,"0",IF(AC17<AC24,??????????


AC17 = 33 (total hours actually worked this week)

AC18 = 8 (total hours paid for Holidays)

AC19 = 41 (total of Cell AC17 + AC 18)

AC24 = 40 (total regular paid hours in a normal work week)


AC27 = I want this cell to = 0 if AC17 is greater than AC24; however, if AC17 is LESS than AC24, I want this cell to equal AC19 - AC24


I think I have the first part of the formula figured out but I cannot get the second half to calculate correctly (where I have the ??????).

 

[Marc L]

(Pas le bonjour non plus ...)


Logically, only one part is necessary !   So try this :  =IF(AC17<AC24,AC19-AC24,0)