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

Question

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?

Answer 1

How about these:

• For the current date: Press CTRL+SEMICOLON
• For the current time: Press CTRL+SHIFT+SEMICOLON
• For the current date and time: Press CTRL+SEMICOLON then SPACE then CTRL+SHIFT+SEMICOLON

Answer 2

Just add =NOW() in a cell.

Answer 3

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

see also http://office.microsoft.com/en-us/excel/HP030561071033.aspx

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