Dear all,
I can't solve a time constraint problem and I think thats quite tricky
so I try to make it clear such that seek any proficient programmer ca
help me.
Pls see my simple attach file when understand my case.
I have some shifts, A, B, C, D and 2 part time pattern. In which eac
has its start time and finish time. In between, there are some lunc
break. You can identify them in my file. A1 and A2 is the same shif
except different lunch break. The same for B, C and D, there ar
however no lunch break for part time.
What I want to do is specify he You can see a matrix contain only
or 0 from column C to L. The pattern will be 1 if the shift cover th
period shaded in purple and 0 otherwise. Those 1 and 0 is done manuall
now. Are there any method such that when I change the start time (finis
time change automatically by start time + 8:30) then the matrix ca
update automatically? It is easy if the shift start at 08:00-16:30 jus
using If function. It is however difficult to update the matrix if ther
is a shift
22:00-06:00. Moreover, in between there should be a lunch break als
specify by its start time such that inside those 1, there are some 0 i
between for lunch to specify those people do not present at that time.
Pls help and thanks so muc

+-------------------------------------------------------------------
|Filename: Book1.zip
|Download: http://www.excelforum.com/attachment.php?postid=2698
+-------------------------------------------------------------------

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