up vote 3 down vote favorite
1
share [g+] share [fb]

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!

link|improve this question
81% accept rate
feedback

2 Answers

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.

link|improve this answer
+1. Beat me to it. – Randolph West Aug 13 '10 at 16:11
Luck is on my side today ;) – Mehper C. Palavuzlar Aug 13 '10 at 16:13
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 C. Aug 13 '10 at 16:17
1  
@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
show 5 more comments
feedback
up vote 5 down vote

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: http://office.microsoft.com/en-us/excel-help/insert-the-current-date-and-time-in-a-cell-HP003056107.aspx

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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