Thread: Time Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DwightA DwightA is offline
external usenet poster
 
Posts: 2
Default Time Sheet

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.