Automatic change for time constraint
 

Moreover, if there is a lunch break, say from 19:30-4:00 that shift
there is a lunch break at 23:00-00:00 (User define its start time an
the matrix will update automatically). How can I update that? I know i
would be very complex of the formula.
Sorry for my poor programming skill.
Thanks
Bon

--
bon
-----------------------------------------------------------------------
bong's Profile: http://www.excelforum.com/member.php...fo&userid=1508
View this thread: http://www.excelforum.com/showthread.php?threadid=26722