Time Sheet

[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.

 

[Elkar]

Rewrite your formulas in E10 and F10 to look like:

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

HTH
Elkar

 

[DwightA]

Thank you very much. That solved the problem.

Rewrite your formulas in E10 and F10 to look like:

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

HTH
Elkar