Not sure I completely understand. Is the formula

=IF(SUM(L5:L10)40,0,IF(SUM(L5:L10)<40,([b]40)-SUM(L5:L10),MIN(8,K11)))

designed to give Saturday hours which should be assigned to regular? Is
K11 Saturday hours, if so try

=IF(SUM(L5:L10)40,0,40-MAX(0,SUM(L5:L10,K11)-40))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521215