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