I hope someone can point me to the right direction,

I have rows upon rows of records on who shipped what and at what time. I
want to see the elapse time for each shipment by user. The problem is that I
can do a sort of the time and subtract the time in row 1 from row 2 to get
the time, but I want to narrow it down by user so this approach would not be
a good idea. So if row 1 had user x shipping and row 2 had user y shipping
this method would not work.

I am wondering if there is a macro or formula to subtract the elapse time
for each shipment by user, for example:

Time User Elapse Time by user
9:32:00 AM Bob 0:04:00
9:31:00 AM Joe 0:11:11
9:28:00 AM Bob 0:09:00
9:20:00 AM Joe 0:02:00
9:19:00 AM Bob ???
9:18:00 AM Joe ???

(the reason why I have the last 2 records as ? is because I do not have any
more data before this shipment to compare it to)
The time is sorted in descending order, if threre is a way of coming up with
the elapse w/o sorting that would be awesome.

Thanks for any help!!!

why not sort by user and then according to time. does it
help
in exel (mine excel 2000) you can sort on three parameters simultaneously



Jane wrote in message
...
I hope someone can point me to the right direction,

I have rows upon rows of records on who shipped what and at what time. I
want to see the elapse time for each shipment by user. The problem is that
I
can do a sort of the time and subtract the time in row 1 from row 2 to get
the time, but I want to narrow it down by user so this approach would not
be
a good idea. So if row 1 had user x shipping and row 2 had user y shipping
this method would not work.

I am wondering if there is a macro or formula to subtract the elapse time
for each shipment by user, for example:

Time User Elapse Time by user
9:32:00 AM Bob 0:04:00
9:31:00 AM Joe 0:11:11
9:28:00 AM Bob 0:09:00
9:20:00 AM Joe 0:02:00
9:19:00 AM Bob ???
9:18:00 AM Joe ???

(the reason why I have the last 2 records as ? is because I do not have
any
more data before this shipment to compare it to)
The time is sorted in descending order, if threre is a way of coming up
with
the elapse w/o sorting that would be awesome.

Thanks for any help!!!