Hi Gally,
Just an idea....
If you can control the update delay on A1, and assuming you aren't trying to keep a running list of historical changes, I was thinking you could have another cell, maybe A2, update itself from A1 but with a 2 second delay after A1 updates. Then have a 3rd cell, A3, just subract A2 from A1. That should (theoretically) give you 13 seconds to read the actual change.
Can you control two separate delays on the same sheet?
Bookmarks