Thanks for the code, it is however quite difficult to understand.
Would you mind implementing the shift C1 in my file in which the time
for the shift is 19:30 to 4:00 such that inside the period, 1 will be
presented using your formula?
You can change the format of the page as you like
Hope that not cause too many troubles to you
Thank you
Bong


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