Time Sheet

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

Elkar

Rewrite your formulas in E10 and F10 to look like:

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

HTH
Elkar
 
D

DwightA

Thank you very much. That solved the problem.

Elkar said:
Rewrite your formulas in E10 and F10 to look like:

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

HTH
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top