Calculating duration based on NETWORKDAYS + working time

[dellzy]

Hello experts,

Usually we use this formula to calculate duration that one uses to handle a case in ticketing/helpdesk/servicedesk system :-
=NETWORKDAYS(date1,date2,[holidays])

But how about if we want to significantly count the SLA days start from the working hours as well? For example, if working hours starts from 9.00am til 5.00pm, if there's a case assigned at 6.00pm, the SLA days should start from the next business day.otherwise, it won't be a fair calculation for the staff as we don't provide 24hours service at the moment.

Any particular modification on the existing formula to cater for this,please?

Please advice. Thank you.

 

[DRSteele]

I'm so glad you feel that way. could you sign up and vote for the creation of this kind of function? If enough votes accumulate, Microsoft might make it a reality. Create NETWORKHOURS as a new function

 

[dellzy]

Hi

I have voted earlier before I responded to your post. I signed up using my FB account Dahlia Zainudin.

Anyway,thanks again for your link and leads. Have a pleasant day.

DZ