vishal0589
Board Regular
- Joined
- May 13, 2014
- Messages
- 63
Hi Friends,
I am working with a attendance register where I have to check gap between two subsequent Weekly Offs (W/O) with following conditions.
-> There must be 4 Present (P) between two Weekly Offs (W/O).
-> If Minimum 4 present (P) is not available between two Weekly Offs (W/O), dates of W/O will be resulted in columns
for example.
<colgroup><col span="2"><col><col span="17"></colgroup><tbody>
</tbody>
<colgroup><col span="2"><col><col><col span="18"></colgroup><tbody>
</tbody>
Please help me out.
Thanks in Advance.
CMA Vishal Srivastava
I am working with a attendance register where I have to check gap between two subsequent Weekly Offs (W/O) with following conditions.
-> There must be 4 Present (P) between two Weekly Offs (W/O).
-> If Minimum 4 present (P) is not available between two Weekly Offs (W/O), dates of W/O will be resulted in columns
for example.
S. No. | Emp. No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Output | ||||
1 | 143 | P | P | P | P | W/O | P | P | W/O | P | P | P | P | W/O | 5 | 8 | |||
2 | 499 | P | W/O | P | P | P | P | W/O | P | P | P | EL | EL | W/O | 7 | 13 | |||
3 | 501 | P | P | P | P | CL | P | P | P | P | W/O | P | P | P | |||||
4 | 505 | P | W/O | P | P | P | P | W/O | CL | P | P | P | W/O | P | 7 | 12 | |||
5 | 506 | P | P | CL | P | P | W/O | P | EL | P | P | W/O | P | P | 6 | 11 | |||
6 | 509 | P | W/O | P | P | P | P | W/O | P | P | P | P | CL | P | |||||
7 | 758 | P | W/O | P | CL | CL | P | W/O | P | P | CL | P | W/O | P | 2 | 7 | 12 |
<colgroup><col span="2"><col><col span="17"></colgroup><tbody>
</tbody>
<colgroup><col span="2"><col><col><col span="18"></colgroup><tbody>
</tbody>
Please help me out.
Thanks in Advance.
CMA Vishal Srivastava