Totals output for last post ( HTML )
Excel 2007 32 bit
B C D E F G H I J 34 TOTAL NO. OF DAYS -----> 25 Normal Overtime -----> 39 Holiday Overtime -----> 18 After121
Worksheet Formulas
Cell Formula C34 =30-COUNTIF(K1:K31,"ABSENT") G34 =SUMIF(L1:L31,"N",J1:J31)*24 J34 =SUMIF(L1:L31,"H",J1:J31)*24




Reply With Quote
Bookmarks