Calculating duration based on NETWORKDAYS + working time

dellzy

Board Regular
Joined
Apr 24, 2013
Messages
146
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.
 
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
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top