Hello all,

I have written a long macro that, in the end, puts two lists next to each other and tells me whether there are any discrepancies between them. However, it's finding discrepancies that aren't actually discrepancies, and I can't figure out why.

First, the image to show you what I mean while I talk about what's going on in this post:
xvXWn9p.png

Column B and C started out as a date/time that I've turned into just a time with the following code buried in a loop that goes through all rows of the document:
            With ActiveSheet.Cells(SelectedRow, 2)
                .Value = .Value - Int(.Value)
            End With
            With ActiveSheet.Cells(SelectedRow, 3)
                .Value = .Value - Int(.Value)
            End With
Column H and I were times only to begin with.

Equality is checked with =IF(INDIRECT("$B$1")=INDIRECT("$H$1"),"","X") - I need to use Indirect here because I may need to move values up and down the list if a name is on one list and not another, but this shouldn't be any different from =IF(B1=H1,"","X").

As you can see, it's only flagging times ending in :00 as errors, while correctly identifying that the times ending in :30 are equal. I have no idea what is causing this. Can anyone help with this?

Thanks in advance