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

Occasional Visitor

# 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?

# Re: Service. Have to release cargo in less than 6 hours. How to measure it within workable hours, on

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