I am looking for a solution after a long trial and error workings. I have 2 columns in and out with date and time. I want to check if the in and out falls between the interval 10PM to 8AM of next day. Further, for those which falls within this range, I want to check atleast minimum of 3 hours are falling within this interval. My data looks like below in col A and B.
I need the output in column C and D where column C gives me the in and out time falls between the interval and Col D give me if it falls more than 3 hours between 10PM to 8AM.
Bookmarks