Hi all,
I have a simple ticket system using a SharePoint online list. There is a status column with Pending (default), Working, Closed.
I have a simple calculation that takes the Closed Date (captured when user puts status in Closed) and subtracts the Created date and gives me the total hours worked (just SP calculated column).
Now the user wants to know if we can add a Paused status that will stop the time calculation until the ticket is put back into a Working status and i'm thinking a Flow would better manage this.
So for example a ticket is submitted at 8:00 am and goes from Pending to Working until 10:00 am when the technician places it in a Paused status due to waiting on a vendor. So right now there is 2 hours worked.
The ticket stays paused until 2 pm when the technician puts it's back into a Working Status until 4 pm when it is placed back into Paused because it is now end of day.
So that would only add another 2 hours worked for a new running total of 4 hours.
The next day at 8 am the ticket is now Working again until 11 am when it is closed - so the complete total working hours on that ticket should come up to 7 hours.
I am unsure about how this might work with a flow - would i just use conditions? or a pause until condition is met? Would this make sure that the Flow doesn't try to restart on every change? Looking for recommendations or ideas 🙂
Thanks!
