Forum Discussion
mmarion
Dec 28, 2020Copper Contributor
Auto update of time function
I am preparing a project log using excel and the now function. My problem is auto-updating of the worksheet results in time difference =0? How to do it? I usually want auto-update. I am not sure how to change this option? Can you help? Thank you.
Sincerely,
MM
- Don't actually hit the "+" key. The "+" key just means to hit/hold the other keys at the same time.
Hold down the Ctrl and Shift keys, then hit the ":" key.
16 Replies
Sort By
- JMB17Bronze ContributorThe NOW function is volatile and re-calculates whenever Excel re-calculates. You could use the keyboard shortcut Ctrl+Shift+: to enter the time.
- mmarionCopper Contributor
When I use the shortcut you described the insert menu opens and the two cells to the right have the current time inserted? This is unreal! MM
- JMB17Bronze ContributorDon't actually hit the "+" key. The "+" key just means to hit/hold the other keys at the same time.
Hold down the Ctrl and Shift keys, then hit the ":" key.