my existing formula for deducting a varible time from a range of times is
=IF(K3>=J7,(IF(K3<=K7,(K7-J7-M3),0)),0) this works fine and if thre is no break to deduct in cell m3 it returns a 0 result ,however when i have tried to extend the cells to be evaluated the result returns as false ,this causes a problem as the cell is a total the formula i have tried is =IF(K3>=J7,(IF(K3<=K7,(IF(K4>=J8,(IF(K4<=K8,(K8-J8-M4),0)),0)))))
any help would be appriecated
Bookmarks