Automatic change for time constraint
 

Oh yes! This can solve the lunch problem, the problem that for a shif
19:30-4:00, the period after 00:00 is still 0 which should be 1 b
using your formula is not okay yet.
:confused:
Thank yo

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