Hi all,

The formulas below calculate if any additional hours are worked by a staff member on a particular day.

=ROUND(IF(ISNUMBER(G39),H39-G39-'Hours Matrix'!D26-IF(AND(G39<0.500694444,H39>0.60416667),1/24,0),0)*96,0)/96

=ROUND(IF(ISNUMBER(G19),H19-G19-'Hours Matrix'!D6-IF(AND(GI9<0.500694444,H19>0.60416667),1/24,0),0),15)

I have listed both formulas above as though they both currently do what I ask I'm not sure if it would be easier to achieve what I would like with one over the other.

Currently when a shift is entered in H-G cells which is shorter than the normal shift length for a staff member on a particular day (Hours Matrix D6/D26) the value returned is negative so ### is displayed. I would like the formula to return an error message stating the problem rather than just returning ###.

Hope this makes sense,

Thanks,

Luke