Hello again,

Can there only be 8 hours max assigned to regular hours from the
Saturday?

If so

=MIN(8,MEDIAN(K11,40-SUM(L5:L10),0))


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