Hi All

I am trying to find the record time stamp for ID between dates
First record: = if 118655 is between 15/7/05 and 15/7/05 ANSWER
12:43:23
Last record: = if 125092 is between 15/7/05 and 15/7/05 ANSWER
10:01:05

Thanks in advance.


A/[INDENT] B/[INDENT] C
Date/[INDENT] id[INDENT] Time
15/07/2005 118655 12:43:23
15/07/2005 118655 16:54:19
16/07/2005 118655 07:59:43
15/07/2005 125092 08:29:37
15/07/2005 125092 10:01:01
15/07/2005 125092 10:01:05
16/07/2005 125092 10:27:01


--
mathewheys
------------------------------------------------------------------------
mathewheys's Profile: http://www.excelforum.com/member.php...o&userid=25093
View this thread: http://www.excelforum.com/showthread...hreadid=388215

sorry, I do not understand your question

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=38821

duane Wrote:
> sorry, I do not understand your question.

I have updated what i am trying to do


--
mathewheys
------------------------------------------------------------------------
mathewheys's Profile: http://www.excelforum.com/member.php...o&userid=25093
View this thread: http://www.excelforum.com/showthread...hreadid=388215

First, keep to the same thread please.

Second, it is not clearer to me.

--
HTH

Bob Phillips

"mathewheys" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> duane Wrote:
> > sorry, I do not understand your question.
>
> I have updated what i am trying to do
>
>
> --
> mathewheys
> ------------------------------------------------------------------------
> mathewheys's Profile:
http://www.excelforum.com/member.php...o&userid=25093
> View this thread: http://www.excelforum.com/showthread...hreadid=388215
>