Forum Discussion
Timecard overlaps
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 us...
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.
- Thank you for your response, I did get my example uploaded.
See the attached version. I added the formula, and I also added two conditional formatting rules to highlight the conflicting times.
