Using Min & Max to sort log times.

From: "J.W. Aldridge" <jeremy.w.aldridge@xxxxxxxxx>
Date: Thu, 14 Feb 2008 10:58:24 -0800 (PST)

I have a list of data that I am trying to get my peoples actual
production time down.
I have their names in A, Dates in B, Times they moved work in C.
I need to know the time they started working to the last time logged
(min time value vs. the max time value in column C) for each name &
date in A.
D = the min time for Joe, then Amy
E= the max time logged for each.

A B C D E

JOE 2/14 3:01 3:01 3:15
JOE 2/14 3:15
JOE 2/14 3:30
AMY 2/14 3:31 3:31 4:15
AMY 2/14 4:00
AMY 2/14 4:15

Any ideas or suggestions???

.

Follow-Ups:
- Re: Using Min & Max to sort log times.
  - From: Max

Prev by Date: Open work*** by date
Next by Date: Re: find from right?
Previous by thread: Open work*** by date
Next by thread: Re: Using Min & Max to sort log times.
Index(es):
- Date
- Thread