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