Calculating Difference based on following value

[thelegazy]

I need help making a macro that will calculate the difference between two activities based on the following activity. I have attached a sample workbook.

So, I want to be able to calculate the time difference between cells from column G when the New Status is "complete" and the one underneath it is either "Available, transit, up". I know the last two aren't on the spreadsheet, but they are in the master sheet.

Is this possible? I would like the values to be pasted next to the "complete" value in column J. I have included a time calculation formula if needed.

Any help would be appreciated.