Home » Questions » Computers [ Ask a new question ]

What's the easiest way to get current time into a field in Excel?

What's the easiest way to get current time into a field in Excel?

I'm recording results into an Excel spreadsheet, and I want to record the time I enter the results. In Notepad, one can simply press F6 to get the current time stamp. Is there a simple/easy way to do this in Excel?

Asked by: Guest | Views: 79
Total answers/comments: 2
Guest [Entry]

"How about these:

For the current date: Press CTRL+;
For the current time: Press CTRL+SHIFT+;
For the current date and time: Press CTRL+; then SPACE then CTRL+SHIFT+;"
Guest [Entry]

"There are shortcuts for date (CTRL+;) and time (CTRL+SHIFT+;)

see also: Insert the current date and time in a cell

For other language versions of Excel the shortcuts are a little different. For the german version the shortcuts are CTRL+. and CTRL+SHIFT+."