Compare Dates/Times on Two Separate Sheets

I am trying to compare dates and times on two separate sheets. On Sheet1 I have a list of dates and times as m/dd/yyyy hh:mm. On Sheet2 I have a list of dates and times as m/dd/yyyy hh:mm. I use this formula in Sheet1:

Formula:

Please Login or Register  to view this content.

which returns FALSE even though it should return TRUE. If I then enter the contents of Sheet 2 into Sheet 1 and use the formula:

Formula:

Please Login or Register  to view this content.

it correctly returns TRUE.

It's the exact same data! Why is this happening?

Yes, I know I can just copy the Sheet2 data into Sheet1 to get it to work, but it's inelegant and it gives me extra columns to hide (this data should be hidden from the person receiving the output) instead of just hiding a sheet. It's driving me nuts!

Originally Posted by FDibbins

It sounds like some of your data may be text, and not values/dates

That's what I thought at first, but I checked it like three times and nope, that's not it.

I uploaded the wrong sample originally. The correct sample does have absolutes as in your example. It's this one:

Turnaround Time Sample Corrected2.xlsx

It has to be both. That's the point. If the entry date was after 5pm on Friday AND before 8am on Monday then it was entered on the weekend and the turnaround should be completion time minus 8am on Monday. So something entered on Saturday and completed Monday at 11am should show 3 hours (Monday 11am - Monday 8am).

If you look at column H, it has the exact same formula but it returns the correct results.

Well well well. I wonder how many times I was going to look at that before I saw it.

Thanks.