Time Sheet

  • Thread starter Thread starter DwightA
  • Start date Start date
D

DwightA

If "RDO (Regular Day Off) is entered into C9 (Time In), the result in E10
(Total Hours worked) and F10 (Pay Hours) reflects #####, ##### rather than
either blank or 0. How can I create a formula so that when RDO is entered
into cell or left blank, the Total Hours Worked and Pay Hours cells remain as
0?

Thank you.
 
Rewrite your formulas in E10 and F10 to look like:

=IF(OR(C9={"RDO",""}),0,YourFormula)

HTH
Elkar
 
Back
Top