You could change the < to a =


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"bong" wrote in message
...

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 and
the matrix will update automatically). How can I update that? I know it
would be very complex of the formula.
Sorry for my poor programming skill.
Thanks
Bong


--
bong
------------------------------------------------------------------------
bong's Profile:
http://www.excelforum.com/member.php...o&userid=15087
View this thread: http://www.excelforum.com/showthread...hreadid=267228