I need a way to put the current time in a cell when I press a key, later put then currnet time in a second cell and calculate the elapsed time. in antoher cell. It would be easy if the NOW function were not volatile, but it is. And there is a shortcut key for the date.Is there a shortcut key for the time?
Can anyone help?
CTRL + Shift + ; for adding the time.
Thank you. It works perfectly.
You're welcome.
Ad Choices