Well, I assumed the times reside in Column B. If not then replace it with whatever you want in the below code.
![]()
Sub DeleteTimes() Dim h As Double, r As Integer, i As Integer r = Cells.SpecialCells(xlCellTypeLastCell).Row With ActiveSheet For i = r To 1 Step -1 h = VBA.Hour(.Range("B" & i)) + 60 * VBA.Minute(.Range("B" & i)) If h < 7 Or h > 19 Then .Rows(i).EntireRow.Delete If h > 10 And h < 16 Then .Rows(i).EntireRow.Delete Next End With End Sub
Bookmarks