For each "manager" for each "date worked: in a list of 10,000 rows I want to find the maxium time worked for that "date worked" (earliest "start time" minus latest "end time")
Ultimately I need to write the result to a summary array "manager", "helper", "date worked","total time worked" (for the values associated with a manager and the date)
I would like this done in excel in an array if possible. If done in access I will need additional help to setup, report and graph results.
Thanks in advance for trying.