• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find Time overlapping based on two criteria's

RSHA

New Member
Hi Excel team, can some one help me in this regard. I have attached excel file with instructions.

Thanks for you help.
 

Attachments

  • Find Time overlapping based on two criterias.xlsx
    12.6 KB · Views: 4
Hi ,

See the attached file.

The first formula in cell G2 is : =IF((D2-C2)>TIMEVALUE("00:03:00"),"VALID","INVALID")

The other cells have a different formula , which is :

=IF(E3 < TIMEVALUE("00:03:00"),"INVALID",IF(A3=A2,IF(B3=B2,IF(C3<D2,"INVALID","VALID"),"VALID"),"VALID"))

Enter this in G3 and copy down.

Narayan
 

Attachments

  • Book2 (3).xlsx
    13.1 KB · Views: 8
Last edited:
Awesome Narayan, Thanks a lot its working fine with one shot. Really you helped me a lot.

Once again thank you soo much..
 
Back
Top