Right I am hitting a brick wall/having a mind blank with this.
I have a sheet that tracks my hours at work, on the front page I call in the values from the end of the week so as an example Cell C3 = ='JAN 14'!F12
From there I want to calculate how many hours I have done extra/under for the week, G1 cell is 37:30 hours. So in cell D3 I do = C3-G1.
What the problem is that if cell C3 is 0:00 hours I return a -37:30 in column D3...which in turn through my TOIL (done in a totally different cell) tracking into a constant minus figure.
What I want cell D3 to do is ONLY do the calculation of C3-G1 when the value is higher then "0:00" in cell C3. But im failing
The cells are formatted in hh:mm format.
Anyone able to other some help? I have tried a SUMIF statement but it fails.
I have a sheet that tracks my hours at work, on the front page I call in the values from the end of the week so as an example Cell C3 = ='JAN 14'!F12
From there I want to calculate how many hours I have done extra/under for the week, G1 cell is 37:30 hours. So in cell D3 I do = C3-G1.
What the problem is that if cell C3 is 0:00 hours I return a -37:30 in column D3...which in turn through my TOIL (done in a totally different cell) tracking into a constant minus figure.
What I want cell D3 to do is ONLY do the calculation of C3-G1 when the value is higher then "0:00" in cell C3. But im failing
The cells are formatted in hh:mm format.Anyone able to other some help? I have tried a SUMIF statement but it fails.
