VBA to find values between a range of specific times and replace.

[RedOctoberKnight]

Good Morning,

I have the following code that I'm hoping to adapt so that I can find specific times that fall within a range and replace them with a "".

Range("AC17:AC57").Replace What:="12:00:00 AM", Replacement:="", ReplaceFormat:=False

Ultimately I want it to find times between "12:00:00 AM" and "05:00:00 AM" and replace them with a "".

Any insight or direction would be much appreciated.

Thanks

 

[Crystalyzer]

What data is currently in those cells? Is it date and time or just time?

 

[RedOctoberKnight]

What data is currently in those cells? Is it date and time or just time?

it's just a time

 

[Crystalyzer]

Try this on a copy of your workbook

Sub RemoveTime()
    Dim r As Range, c As Range
    
    Set r = Application.InputBox("Select Range", "Remove Time", , , , , , 8)
    
    If Not r Is Nothing Then
        
        For Each c In r
            If c >= 0 And c <= 0.208333333333333 Then c = ""
        Next
    
    End If
End Sub