goodmorning
I want to use excel for SLA calculation, but no idea where to start
SLA begin : 17/04/2019 08:04
and SLA is 16h, how do I automatically calculate the end time?
businesshours are from 08:00 - 20:00, so they need to be included aswell.
thank you
Hello Trien and Welcome to Excel Forum.
I believe that dflak's workhours macro will do what you want. Below is a link to the thread in which the macro is included.
https://www.excelforum.com/tips-and-...workhours.html
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
As this is posted in the formulas forum, here is a purely formula based proposal.
The duration left for any particular day is displayed using the MIN function and is similar to: =MIN(TIME(20,0,0)-TIME(8,0,0),B3-C3)
The end time for any particular day is displayed using formulas similar to: =IF(E3>0,WORKDAY(A3,1)+MIN(TIME(8,0,0)+E3,TIME(20,0,0)),"")
Note that for durations of more than 36 hours more days will need to be added to the three modeled in the attached file.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks