I have 2 data sets in the following format. One set is Fish A (shown below) and the other is Fish B (not shown).
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:35:55
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:38:17
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:40:58
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:45:15
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:48:46
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:51:21
S,00569, Fish A, 70.0, 1040, 05/05/09, 23:54:05
S,00569, Fish A, 70.0, 1040, 05/06/09, 00:02:10
S,00569, Fish A, 70.0, 1040, 05/06/09, 00:05:08
S,00569, Fish A, 70.0, 1040, 05/06/09, 00:06:05
S,00569, Fish A, 70.0, 1040, 05/06/09, 00:09:20
S,00569, Fish A, 70.0, 1040, 05/06/09, 00:11:35
I need a programmer to compute the the time difference between each line. For example, the first line would be 23:38:17 – 23:35:55 = 142 Seconds. The first data set has about 15,000 lines and the 2nd data set has about 5,000 lines. The programmer can write a script in any programming language to do this. I don’t need the script, I just want the final result in a Microsoft Excel file. I want the original data sets along with the time differences in Seconds next to them so I can clearly see and check the data at random points. Two graphs must also be plotted (one for Fish A, and one for Fish B), and must be in the same excel file. For the graphs, use the time difference in Seconds as the Y variable and the data/time as the X variable. I have attached the text files for each data set.
I can not provide any software to do this, you must be able to produce a Microsoft Excel file. I can only pay with Paypal at this time.