If .Cells(idel, "C") > "17:35:00" And .Cells(idel, "C") < "08:55:00" Then
Unless 08 is the next day, it can not be less than 17.35.
For e.g 19:15:01
which is the last row is greater than 17:35:00, but it can not be less than 08.55.
If I were to convert the time in to digital, I get the following
0.371539352: for 08:55:00
0.802094907:19:15:01
0.802094907 can be less than 0.371539352
Bookmarks