All,

I am in charge of Payroll. I have taken several classes regarding Excel, but I cannot seem to figure this out...

I export 400 employees' clock-in and out times to Excel 2007. I usually manually look for overlapping punches, meaning an employee is getting paid twice for the seconds, minutes, or hours worked.

I do not know how do do this!

Here is what I look at for 400 employees:

Time In Time Out
6/16/2012 22:14 6/17/2012 7:17

Time In is Column D and Time Out is Column E.

The first row is 2 and the last row is 2807.

Help?!

Thanks!