Forum Discussion
Logging Tickets in Working Hours (Issues list)
I have a Sharepoint Issues List.
We set the ticket logged time as the item Created Date (ie. 20/06/2025 10:00)
We then set a deadline by adding x hours to the Created Date based on the category. (ie. 2hr, 3hr, 24hr, 36hr, 72hr etc).
We further move the SLA Deadline if it drops on a Saturday or Sunday (Add 24 or 48hrs based on day of week).
Our support team work 8am - 4pm, so they have asked if we can look at not having the SLA Deadline landing when they are not on shift.
In my mind, we would create a temp calculated column that works out of the deadline time is after 4pm, and before 8am, and if so, then add 16 hours to it (16 hours is the time they are offline - 4pm - 8am)
Does anyone know the formula you would use to do that calculation ?
1 Reply
Hi IanOffers
I guess you can use a similar approach to your weekend calculation for the hour check as well. The only difference would be how you retrieve the hour value. You can do this using the following formula.
=VALUE(TEXT(TestDate,"HH"))
The result will be as follows:I’m also wondering, if you don’t want to use Power Automate for more complex calculations, you could add additional conditions based on vacation dates, for example.
