So I am looking for a alternative way to create timers than what I have done. I currently use circular referencing to create timers and as you can imagine circular references are volatile at best in most cases.
What I am doing is I have a queue where employees add themselves, they can only remain in the queue at the top for up to 20 minutes. After the time has expired or they are manually removed the timer starts again for the next person in the queue. This is currently done by one column listing the number in queue that the employee is. When someone is listed as number 1 the timer starts, when their time has passed or they are listed as taken off that number becomes a ZERO and the next person becomes number 1. This works currently but it requires me to keep the workbook open at all times for it to not malfunction. I am looking for a more simple alternative. Keep in mind that using onEdit will not work because when a timer runs out the formulas make the changes and it is not considered a worksheet edit. Because of this the onEdit script does not trigger. Anyone have any ideas?