Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

up vote 10 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. –  w3d 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.