time interval

[earp_]

Hi I have this problem,
in cell A2 of sheet1 there is a timestamp in this format
12:00:00 PM
When cell A2 of sheet1 is between 12:00:00 and 12:59:59 I want to write 'hello' into another cell: A4 of sheet2

How does it work?

Thanks in advance

 

[earp_]

thanks. I will in my next posts.

 

[earp_]

Really thanks for all the support.
My last question is the follow one:

'7.05
If .Value >= TimeSerial(7, 0, 0) And .Value < TimeSerial(7, 5, 0) Then
With ThisWorkbook
Worksheets("Sheet1").Range("B2").Copy
Worksheets("Sheet2").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlValues
End With
End If

Now, I want to do things every 5 mins from 7AM to 7PM and every 5 mins I want to copy my values into a different column
I think is quite silly to write more than 100 IFs
How can I fix that with a for loop?