Find and list matching values in different sheets

[MindToAsk]

Hi guys,

I have the following situation:
- 2 sheets representing the in (first sheet) and out (second sheet) time for specific transactions
- I need to list on a third sheet the in and time and out time for the same name; difference between out and in (if difference exceeds 4 hours, the number of minutes must be multiplied with 0.25, and the result shown in the Difference column)
- the result page needs to filter out rows in sheets 1 and 2 which does not contains the word "Acces" or "Abonament" or "Insotitor"
- some of the records will have only the in or out time - these need to be listed on the 3rd sheet as errors
- some of the records will have two or more in or out time - these alse need to be listed on the 3rd sheet

Here is an example:


-------- sheet 1 ------

TIME NAME ID EVENT

8:04:50 Acces Gold GLD-A808* 3885* Allowed Normal In*
8:04:53 Acces Gold GLD-A713* 2088* Allowed Normal In*
8:11:04 Acces Gold GLD-A778* 2153* Allowed Normal In*

-------- sheet 2 ------

TIME NAME ID EVENT

9:31:47 Camera 311* 3873* Allowed Normal Out*
9:40:17 Acces Gold GLD-A808* 3885* Allowed Normal Out*
9:40:37 Acces Gold GLD-A713* 2088* Allowed Normal Out*
9:58:19 Camera 312* 3766* Allowed Normal Out*



RESULT
-------- sheet 3 ------

IN OUT NAME TIME DIFFERENCE COST EVENT IN EVENT OUT
8:04:50 9:40:17 Acces Gold GLD-A808 1:35:27 - Allowed Normal In Allowed Normal Out
8:04:53 9:40:37 Acces Gold GLD-A713 1:35:44 - Allowed Normal In Allowed Normal Out
-------
TOTAL 3:11:11 -




Can anyone help me out here? Thank you. I have attached the actual excel file (it already contains a script to format the data)