troubleshooting Question

Excel Spreadsheet Timer Out-of-Sync

Avatar of cpatte7372
cpatte7372Flag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
5 Comments1 Solution320 ViewsLast Modified:
Hello Experts,

Its tricky trying to explain this request. However, here goes.

Basically, the timer in cell AZ2 is out-of-sync. The timer is accessed at various intervals. For example, at 9:14, or 9:19 or 9:24 the timer will be activated and count down for a minute. During that minute the timer will either be out-of-sync with the clock on the pc or it may skip a few seconds e.g. jump from 9:14:10 to 9:14:14.

Is there another another that can be used with spreadsheets? Basically, where is =NOW() taken from?

Cheers

Carlton
dynamicV4.xlsm
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros