Formatting the Current Time

An Excel Keyboard Shortcut

This Excel tip shows you how to format the current time (hour, minute, and AM/PM format) in an Excel spreadsheet using a keyboard shortcut.

Formatting the Current Time using a Keyboard Shortcut

1. Use the NOW function to add the current date and time to cell D1.
   
   
2. Click on cell D1 to make it the active cell.
   
   
3. Press and hold down the Ctrl and Shift keys on the keyboard.
   
   
4. Press and release the number two ( 2 ) on the keyboard without releasing the Ctrl and Shift keys.
   
   
5. The NOW function in cell D1 will be formatted to show the current time in the hour, minute, and AM/PM format.
   
   

Other Keyboard Shortcuts

• Excel Undo
• Adding the Current Date
• Formatting the Date