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.
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.