Service. Have to release cargo in less than 6 hours. How to measure it within workable hours, only?

[AleCexcelQ]

Hello,

Have to measure our performance releasing cargo in less than 6 hours, considering the workable hours are from 07:00am to 17:00hrs *Mon to Fri. 

What if we receive instructions around 16:00hrs or after hours?

How to remove them from my result to do not impact my on time performance?

[#2]

Hi @AleCexcelQ 

First, you need to calculate the time taken on all the cargo instructions that are received on or before 16:00hrs. This can be achieved by using the below formula:

=IF(B5>$D$2,"N/A",(C5-B5))

Secondly, you need to calculate the average time taken for applicable instructions only. This can be done using =AVERAGEIFS() function, as mentioned below:

=AVERAGEIFS(D5:D14,D5:D14,"<>N/A")

You may refer to the attached file for more understanding. Please let me know if it was helpful for you.

Thanks

Tauqeer