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:00hrs or after hours?

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

BI & Data Analysis
excel

1 Reply

  • 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