Macro to Look for Differences in Time

[FrenchCelt]

Hello,

I'm building a macro that identifies time errors to be fixed off a report that includes employee clock in/clock out times. The only values that matter are the actual clock out times vs. system clock out times. Specifically, if an employee physically clocked out at one time, but the system shows a later clock out time, it means I need to go fix the problem that caused this discrepancy. I've done all the necessary formatting in my VBA code to make the data useful for sorting, but I can't figure out a way to make the macro compare the time values in one column (Col C) with the time values in the other column (Col E). If they are identical, no problem, but if they are different, I need these to appear either using some kind of conditional formatting that identifies the ones that are different and then filters for that formatting, or conditionally formats the ones that are identical and then sorts them out, only leaving behind the ones that are different. Or maybe one of you knows of another way to achieve this end result without conditional formatting.

Any help would be appreciated.

 

[JLGWhiz]

Dim c As Range, sh As Worksheet
Set sh = ActiveSheet
For Each c In sh.Range("C2", sh.Cells(Rows.Count, 3).End(xlUp))
    If c.Value <> c.Offset(, 2).Value Then c.EntireRow.Interior.Color = vbYellow
Next

 

[FrenchCelt]

Dim c As Range, sh As Worksheet
Set sh = ActiveSheet
For Each c In sh.Range("C2", sh.Cells(Rows.Count, 3).End(xlUp))
    If c.Value <> c.Offset(, 2).Value Then c.EntireRow.Interior.Color = vbYellow
Next

Brilliant! Thank you so much!

 

[JLGWhiz]

Brilliant! Thank you so much!

You are welcome,
regards, JLG