hi..
I have a question....

I want to take the final result of each file( i have some 100 files) and want to make a final worksheet using these data.

for example I have 100 files with like 10 factors (a1---a10) each... I have a start time and a finish time for each of these factors...so my each row now has the total time(difference of the end and the start time)......I want to take this total time frm each row of the file and make a new worksheet with these data....How can I do that?

ex:file 1

strt time end time total time in dd:hh:mm
a1: 1/2/2007 1:30 pm 1/2/2007 2:30pm 00:01:00
a2: 2/2/2007 1:00 pm 2/3/2007 1:00 pm 01:00:00

file 2
.....

I have like 100 files like the above example. I now need to take the total time from each row and put them in a new worksheet and then use that to find the average times for all the a1's---a10's.
Can anyone please help me with this problem. Dont know if i have made myself clear
thanks in advance