Solved Automatic time stamping in excel

July 13, 2012 at 07:20:54
Specs: Windows XP
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?


See More: Automatic time stamping in excel

Report •

#1
July 13, 2012 at 07:32:50
✔ Best Answer
CTRL + Shift + ; for adding the time.

Report •

#2
July 13, 2012 at 08:07:02
Thank you. It works perfectly.

Report •

#3
July 13, 2012 at 10:04:35
You're welcome.

Report •
Related Solutions


Ask Question