Need to find out the employee shift based on his/her login and logout timings

[gaddamharish]

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.

[TABLE="width: 326"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD] In Time [/TD]
[TD] Out Time [/TD]
[TD] Time Spent [/TD]
[/TR]
[TR]
[TD]06/01/2014 12:00:00 AM[/TD]
[TD]06/01/2014 12:00:00 AM[/TD]
[TD]00:00:00[/TD]
[/TR]
[TR]
[TD]06/02/2014 12:00:00 AM[/TD]
[TD]06/02/2014 12:00:00 AM[/TD]
[TD]00:00:00[/TD]
[/TR]
[TR]
[TD]06/03/2014 08:28:00 AM[/TD]
[TD]06/03/2014 04:39:00 PM[/TD]
[TD]08:11:00[/TD]
[/TR]
[TR]
[TD]06/04/2014 07:58:00 AM[/TD]
[TD]06/04/2014 04:36:00 PM[/TD]
[TD]08:38:00[/TD]
[/TR]
[TR]
[TD]06/05/2014 07:58:00 AM[/TD]
[TD]06/05/2014 04:41:00 PM[/TD]
[TD]08:43:00[/TD]
[/TR]
[TR]
[TD]06/06/2014 08:20:00 AM[/TD]
[TD]06/06/2014 05:27:00 PM[/TD]
[TD]09:07:00[/TD]
[/TR]
[TR]
[TD]06/07/2014 08:04:00 AM[/TD]
[TD]06/07/2014 05:16:00 PM[/TD]
[TD]09:12:00[/TD]
[/TR]
</tbody>[/TABLE]

Below are the shift timings . Based on these values,we need to find which shift that employee has worked in:

[TABLE="width: 156"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Start time[/TD]
[TD]End Time[/TD]
[TD]Shift[/TD]
[/TR]
[TR]
[TD]5:00 AM[/TD]
[TD]1:00 PM[/TD]
[TD]EMS[/TD]
[/TR]
[TR]
[TD]1:00 PM[/TD]
[TD]9:00 PM[/TD]
[TD]DS[/TD]
[/TR]
[TR]
[TD]9:00 PM[/TD]
[TD]5:00 AM[/TD]
[TD]NS[/TD]
[/TR]
</tbody>[/TABLE]

Please help me out with the solution.

 

[Andrew Poulsom]

Welcome to MrExcel.

The data you have posted doesn't seem to match any of the shift patterns. Why would someone start 3 hours after a shift begins and finish 3 hours after a shift ends?