Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a time log spreadsheet. I have a new sheet for each day. In each sheet, I have a transactional record of how my time was spent. When I start or end a task, I usually type in the time ("11:00 AM" for example).

Is there a shortcut to inserting the current time into a field? I'm sure it can be done with a macro, but I'm not very knowledgeable about macros. I'd like to simply highlight a field and hit some sort of shortcut key to insert a static value of the current time.

Thanks for any help!

share|improve this question
up vote 11 down vote accepted

Select the cell you want to enter the time, and hold down the Ctrl, Shift and : keys at the same time on the keyboard. This keyboard shortcut will instruct Excel to enter a static time into the selected cell.

share|improve this answer
    
+1. Beat me to it. – user3463 Aug 13 '10 at 16:11
    
Luck is on my side today ;) – Mehper C. Palavuzlar Aug 13 '10 at 16:13
1  
Strictly speaking it's the semi-colon (;), rather than a colon (:) although they are on the same key. – w3dk Aug 13 '10 at 16:15
    
Exactly what I needed. Thanks! – Mike Cole Aug 13 '10 at 16:17
2  
@w3d: On my keyboard (TR-type), they are on different keys. When I use the colon (:) I get the time, and when I use the semicolon (;) I get the date. – Mehper C. Palavuzlar Aug 13 '10 at 16:17

Insert a static date or time:

Current date: Select a cell and press CTRL + ;

Current time: Select a cell and press CTRL + SHIFT + ;

Current date and time: Select a cell and press CTRL + ; then SPACE then CTRL + SHIFT + ;

Source.

share|improve this answer
1  
BTW, for anyone hoping these work in Word, they don't. – krowe Sep 17 '14 at 7:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .