Forum Discussion

J_Lew33's avatar
J_Lew33
Copper Contributor
May 16, 2022

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 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. 

 

https://1drv.ms/x/s!Ani5F3tCY1_Yg6Y7oF6HI2jZSwddrA?e=gAv1oP

 

 

 

Thank you for your time and help. 

excel
Formulas and Functions

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 16, 2022

    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.

Resources