Dec 11 2021 03:11 PM - edited Dec 11 2021 03:12 PM
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?
Dec 12 2021 01:50 AM
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