gaddamharish
New Member
- Joined
- Aug 17, 2014
- Messages
- 1
Hi I am Harish. I have login, logout and time spent in work everyday.
Need to find out the work shift based on the login and logout values.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Below are the shift timings . Based on these values,we need to find which shift that employee has worked in:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Please help me out with the solution.
Need to find out the work shift based on the login and logout values.
In Time | Out Time | Time Spent |
06/01/2014 12:00:00 AM | 06/01/2014 12:00:00 AM | 00:00:00 |
06/02/2014 12:00:00 AM | 06/02/2014 12:00:00 AM | 00:00:00 |
06/03/2014 08:28:00 AM | 06/03/2014 04:39:00 PM | 08:11:00 |
06/04/2014 07:58:00 AM | 06/04/2014 04:36:00 PM | 08:38:00 |
06/05/2014 07:58:00 AM | 06/05/2014 04:41:00 PM | 08:43:00 |
06/06/2014 08:20:00 AM | 06/06/2014 05:27:00 PM | 09:07:00 |
06/07/2014 08:04:00 AM | 06/07/2014 05:16:00 PM | 09:12:00 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Below are the shift timings . Based on these values,we need to find which shift that employee has worked in:
Start time | End Time | Shift |
5:00 AM | 1:00 PM | EMS |
1:00 PM | 9:00 PM | DS |
9:00 PM | 5:00 AM | NS |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Please help me out with the solution.