fareedexcel
New Member
- Joined
- Oct 11, 2017
- Messages
- 1
Dear Experts,
I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="5"><col><col><col><col></colgroup><tbody>
</tbody>
Regards,
Fareed
I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference.
Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | ||||||||||
STAFF NO. | NAME | NORMAL DAYS | SL(Full) | SL(Half) | SL(Nill) | OVERTIME (Off Days) | OVERTIME (Hours) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | INTERVAL | EXPECTED RESULT |
1 | David | 31.0 | 0 | 0 | 0 | 0 | 15.00 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | 5-5-5 | |
2 | Cameroon | 31.0 | 0 | 0 | 0 | 1 | 38.00 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | 5-5-5 | |
3 | Sachin | 31.0 | 0 | 0 | 0 | 1 | 11.50 | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | 6-6-6 | |
4 | Tendulkar | 27.0 | 0 | 0 | 0 | 0 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | 5-5-5 | ||
5 | Rahul | 30.0 | 1 | 0 | 0 | 0 | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | - | - | - | - | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | 5-5-4-5 | ||
6 | Dravid | 31.0 | 0 | 0 | 0 | 0 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | 5-5-5 | ||
7 | Narain | 20.0 | 0 | 0 | 0 | 0 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | - | 5-5 | ||
8 | Karthik | 31.0 | 0 | 0 | 0 | 0 | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | 5-5-5 | ||
9 | Dhoni | 31.0 | 0 | 0 | 0 | 0 | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | OFF | - | 5-5-5-4 | ||
10 | Singh | 12.0 | 0 | 0 | 0 | 0 | 8.75 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | - | - | - | - | - | - | - | - | - | - | OFF | - | - | - | 5-4-10 | |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="5"><col><col><col><col></colgroup><tbody>
</tbody>
Regards,
Fareed