Timecard overlaps

[J_Lew33]

Hi all,

I am trying to find a formula that will check for overlaps within an employees time card. ideally I would like for it to check the end time against the start time of the next row. I am using Military time. In my basic example column E and F show the clocking in and out times for that employee. Row 7 and 8 contain an overlapping of time. This error is what I want to have the formula check against. 

Timecard overlapping example (1).xlsx

Thank you for your time and help. 

[#2]

@J_Lew33 

In an empty column in row 3, enter the formula

=IF(E3<=F2, "Overlap between rows "&ROW(F2)&" and "&ROW(E3), "")

Fill down.

If you cannot attach a sample workbook, you might make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

[#3]

Thank you for your response, I did get my example uploaded.

[#4]

@J_Lew33 

See the attached version. I added the formula, and I also added two conditional formatting rules to highlight the conflicting times.