Required macro to break the time and insert a new worksheet

Please refer my attach file for more clarification.

I want a Macro working who insert the 2 new sheets.

1-Insert One new sheet,only keep all the rows having time 00:00:00 to 12:00:00,appearing in column-'K'. in the attach file.
2-Insert other new sheet,only keep all the rows having time 12:00:01 to 24:00:00,appearing in column-K'in the attach file.

Can it be possible through VBA codes working?

Try this...

Sub CreateSheets()
Dim rMyRng As Range

Set rMyRng = Range("$B$2").CurrentRegion

With rMyRng
    For i = 1 To 2
        If i = 1 Then .AutoFilter 10, ">=00:00:00", xlAnd, "<=12:00:00"
        If i = 2 Then .AutoFilter 10, ">12:00:00", xlAnd, "<=24:00:00"
        Sheets.Add
        .SpecialCells(xlCellTypeVisible).Rows.Copy Range("A1")
        Range("A1").CurrentRegion.EntireColumn.AutoFit
    Next i
   .AutoFilter
End With
   
End Sub

Thanks a lot.Codes are working fine with no problem at all.Glad to find it.

Glad it helps you and thanks for the feedback