Hi,
I have a time sheet for employees that I am having problems with and hope that somebody can help me.

I have 3 colums for each day of the week, which are -

example Monday
B3 (general) 0700
C3 (general) 2100
D3 =IF(SUM(C4-B4)/100>0,(C4-B4)/100,"OFF) which gives me the result of 14

This seems to work fine, but I am having trouble with the final column which will add up the total of Monday -Sunday (D3, G3, etc to V3).
I need this to calculate the total if a number, but I cant get this to work when the result is showing as OFF.

Pulling my hair out on this one. Any help is greatly appreciated.

Thank you
Debbie