What is the formula for finding an average time from another sheet. Please see pics
The avg dwell column is where I want the answer to go. I want the average dwell time for all the SCAC that is associate with CFAA in the first column. the information will be in this sheet
I have tried the averageif formula with the time but do not know how to formulate it. Any help will be appreciate it. Thank you