open csv files, do time stamp difference and paste result

Hi thanks for the response but I realized there is a problem with the data in the csv files.

column A is the time stamp column but the problem is that it does not stay consistent, it changes. What I have found would be best would be to take the last cell in column A and minus it from cell A2 (A1 has wiring in it), this will give me the total time of the file. Then I want to put this in the active sheet, how would I go about doing this?

ok let me try to explain again.

1. I have a folder with .csv files. Those files have many columns in them but the first one A: is a time stamp.

2.What I want to do is fine the total time each file has run.

3.So If I open one file it has a time stamp starting in A2 as 20:29.3 (5/16/2011 5:20:29 am) and in the last cell of column A as 53:24.2 (5/16/2011 6:53:24 am).

4.first I want to turn them into general numbers, so 20:29.3 turns into 40679.22256 and 53:24.2 turns into 40679.28709.

5.Then take 40679.28709-40679.22256 and you have .06453 which means 32.55 seconds

6.Then take that seconds and past it in the current active worksheet, then loop for all files in the active folder.

so this is what I came up with but it only works with one file at a time, I need this to loop though all of the files in the folder.

Please Login or Register  to view this content.

so this is what I cam up with but it only works with one file at a time, I need this to loop though all of the files in the folder.

Please Login or Register  to view this content.

thanks for the response, the thread title was originally what I wanted to do but I noticed after that it would not work right, that is why I want to use the time difference.

can you please explain to me how I put the time difference in the variable, I don't know much about vba, but I am trying to learn. Thanks.

attached is an example of one the the csv files.

I would just turn those into standard excel format, so 20.29.3 would turn into something like 40622.26423