awagdarikar
Board Regular
- Joined
- Jun 20, 2008
- Messages
- 115
Based on the Access Card Swipe data of a employee I have to find out whether he is on time in First / General /Second shift. The Swipe Time data for each employee is in One Column and the Work Shift timings are First= 6:00:00 AM, General= 9:00:00 AM, Second shift= 3:00:00 PM. I do not have shift allocation details of each employee and I want to find out Result, which shift the employee is in (Early / Shift (On Shift time) / Late) based on following 8 conditions
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
1. If Swipe Time is from 12:15:59 AM to 5:59:59 AM, Result should be “Early in First Shift”<o></o>
2. If Swipe Time is from 6:00:00 AM to 6:30:00 AM, Result should be “First Shift”<o></o>
3. If Swipe Time is from 6:30:01 AM to 7:59:59 AM, Result should be “Late in First Shift”<o></o>
4. If Swipe Time is from 8:00:00 AM to 8:29:59 AM, Result should be “Early in General Shift”<o></o>
5. If Swipe Time is from 8:30:00 AM to 12:30:00 PM, Result should be “Late in General Shift”<o></o>
6. If Swipe Time is from 12:30:01 PM to 2:59:59 PM, Result should be “Early in Second Shift”<o></o>
7. If Swipe Time is from 3:00:00 PM to 3:30:00 PM, Result should be “Second Shift”<o></o>
8. If Swipe Time is from 3:30:01 PM to 8:30:00 PM, Result should be “Late in Second Shift”<o></o>
I have been trying very hard to create a Result Column based on above 8 conditions but not able to do so,
Whooooosh Such a long description of a problem,<o></o>
Please help,<o></o>
Ani
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
1. If Swipe Time is from 12:15:59 AM to 5:59:59 AM, Result should be “Early in First Shift”<o></o>
2. If Swipe Time is from 6:00:00 AM to 6:30:00 AM, Result should be “First Shift”<o></o>
3. If Swipe Time is from 6:30:01 AM to 7:59:59 AM, Result should be “Late in First Shift”<o></o>
4. If Swipe Time is from 8:00:00 AM to 8:29:59 AM, Result should be “Early in General Shift”<o></o>
5. If Swipe Time is from 8:30:00 AM to 12:30:00 PM, Result should be “Late in General Shift”<o></o>
6. If Swipe Time is from 12:30:01 PM to 2:59:59 PM, Result should be “Early in Second Shift”<o></o>
7. If Swipe Time is from 3:00:00 PM to 3:30:00 PM, Result should be “Second Shift”<o></o>
8. If Swipe Time is from 3:30:01 PM to 8:30:00 PM, Result should be “Late in Second Shift”<o></o>
I have been trying very hard to create a Result Column based on above 8 conditions but not able to do so,
Whooooosh Such a long description of a problem,<o></o>
Please help,<o></o>
Ani