Excel – Inserting static current time in Excel

microsoft excel

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!

Best Answer

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.