Search Time

[zyhin]

Is there anyway to search time.

I have a numbers of start times that range from 7am to 4pm in the format of hh:mm:ss. Is there any way of finding the last time inputed before a set time in column A

for e.g.

9:35:23
10:45:34
10:56:05
12:52:28

and findng the last time before 11:00:00 = 10:56:05


Z

 

[jeffreybrown]

Try...

=LOOKUP(TIME(11,0,0),A1:A4)

 

[zyhin]

Is there a way to do this in VBA. I am trying to add a line in at 11:00:00

z

 

[jeffreybrown]

Yes, most things are possible in VBA, but it helps when you give a little more detail.

Where do you want to add 11:00:00?
Are you wanting it added to the existing list?
If this number is to be added what do you want done with it?
Do you want 10:56:05 returned somewhere?

 

[zyhin]

I was wanting 11:00:00 put next to it in column B. I have A as start time and B as finish time. I want to clock them out(finished time) at 11am and then will do another for 11:30am to clock them back in again. I know what I need to do to get the rest to work. Its just the finding the time parthave no idea about.

eg

9:35:23 10:45:34
10:45:34 10:56:05
10:56:05 11:00:00 < clock out for lunch​

11:30:00 12:52:28
12:52:28

Z