What is the correct syntax to search and select time values that are in time format?

[WINTER_007]

Hello, pretty new, not to excel but to tinkering at the vba level.

I am trying to do a simple search, select, copy, past on specific times and am hung up at an ultra-basic level.

I can do it if I wiggle around and make time become text and then filter/search by doing this: If Worksheets("Sheet1").Cells(I, 1).Value = "10:00 AM" or

But I have not figured out how to capture it if it is still in time format. It does not work if I put it in quotes like text and it does not work if I just put the value there with no quotes.

What is the right way/syntax to do that.?

Thank you for a pointer here.

Winter

 

[bebo021999]

Instead of "10:00 AM" you can use 10/24 to present 10:00 AM

 

[MARK858]

Maybe something like

Sub FindTime()
    With Range("A2:A9")
        .Find(TimeValue("10:00 AM"), .Cells(.Cells.Count), xlFormulas, , , xlNext).Copy Range("C2")
    End With
End Sub

Book3
	A
1
2	08:00
3	09:00
4	10:00
5	11:00
6	12:00
7	13:00
8	14:00
9	15:00
Sheet3

 

[WINTER_007]

Instead of "10:00 AM" you can use 10/24 to present 10:00 AM

Thank you. That works.

How would I structure the syntax for minutes. So, if for example, it were a search for 10:15 AM rather than 10:00?

 

[WINTER_007]

Maybe something like

Sub FindTime()
    With Range("A2:A9")
        .Find(TimeValue("10:00 AM"), .Cells(.Cells.Count), xlFormulas, , , xlNext).Copy Range("C2")
    End With

[/QUOTE]
I need to tinker with that later, but I see your reference to "find(timevalue.....) and see that that is an area that I want to study up a bit. Did a quick google and saw some good content for later.

Thank you kindly.

 

[WINTER_007]

Maybe something like

Sub FindTime()
    With Range("A2:A9")
        .Find(TimeValue("10:00 AM"), .Cells(.Cells.Count), xlFormulas, , , xlNext).Copy Range("C2")
    End With
End Sub

Book3
	A
1
2	08:00
3	09:00
4	10:00
5	11:00
6	12:00
7	13:00
8	14:00
9	15:00
Sheet3

Thank you kindly. I will tinker with it later and I see your reference to the "find timevalue" and will google a bit to get smarter on that.

 

[bebo021999]

Thank you. That works.

How would I structure the syntax for minutes. So, if for example, it were a search for 10:15 AM rather than 10:00?

Thank you. That works.

How would I structure the syntax for minutes. So, if for example, it were a search for 10:15 AM rather than 10:00?

hour/24+minute/1440+second/3600