Forum Discussion
Solved
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 ...
- 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.
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
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.
Hold down the Ctrl and Shift keys, then hit the ":" key.
All cells are working properly now. Thank you for your help.
I wonder if this could be done without shortcut keys but rather with excel commands of some kind? That is what I was attempting to do.
MM
- You could use the now function, but you would need to hardcode the result to keep it from re-calculating. And, it appears copy/paste special triggers the now function to re-calculate, so excel would have to be in manual calculation mode when you did it.
- Ok. start time and end time can be entered using control shift colon. How should I adjust the subtract time cell? I am using =TEXT(E2-D3,"HH:MM:SS"). It is giving the wrong answer (end time)? MM
- To clarify:
Date Name Project Time1 Time2 Time
20/12/28 XXX A. XXXXXX admin 17:31:00 17:32:00 17:32:00- I suspect the formula should be E2-D2 and not E2-D3?
Also, I just noticed that shortcut does not appear to include the seconds. If that is an issue, then you may consider creating a button and attaching a macro to add the time to the current cell.
Sub GetTime()
activecell.Value = time
End Sub