Forum Discussion

AleCexcelQ's avatar
AleCexcelQ
Copper Contributor
Dec 11, 2021

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

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:00hr...
BI & Data Analysis
excel
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Dec 12, 2021

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