Macro to check data for matches and return a difference

Hello everyone,

I'm working with a large quantity of data that needs to be analyzed by time. My data is inputted into excel through SAP and comes in very sloppy. I created a macro to clean up then data. I need help creating a macro that search for certain conditions of the data and return a value. I'm going to do my best to explain what I'm trying to accomplish but I've also attached a sample of what I would like the macro to do to a range of data.

1) Find the row titled "Status" and then check each column that says "Complete" and "Pending" (no particular order of which comes first) that also have matching values in the "Order" and "Footage" row.

2) If the first condition is true then take the value from the "Operation" column (using the same column that was "Completed") and subtract 20 from that value.

3) Search for said value in the "Pending" column under the "Operation" row.

4) Then subtract the "Time" ("Completed") from the "Time" ("Pending") and place result next to the "Completed" column in the "Time Difference" row.

My sample workbook shows the end result (minus the fill colors).

This is something way out of my depth but I can't think of a better way to get the numbers I need.

Anyone willing to take a look at this for me would be my hero!

Thank you,

-Justair

This is a similar question that I have received help with before but a lot of the criteria is different. Not to mention the macro that I received before worked great as long as the data was structured in a very specific way.
With my new data that's not possible so I'm requesting help considering the new conditions.