S
Steven G
I am trying to create a timesheet. The formula I use to
calculate hours work is =IF(C2>0,IF(D2<C2,(D2+12)-C2,D2-
C2),""). This works well, the problem is when I try to add
the before and after lunch columns, I get this #value in
the total hours worked column when the form is blank. When
there are number in the cloumn everthing is fine. The
formula in that column is =E2+H2. How can I fix it so
#value doesn't show up?
calculate hours work is =IF(C2>0,IF(D2<C2,(D2+12)-C2,D2-
C2),""). This works well, the problem is when I try to add
the before and after lunch columns, I get this #value in
the total hours worked column when the form is blank. When
there are number in the cloumn everthing is fine. The
formula in that column is =E2+H2. How can I fix it so
#value doesn't show up?