Format Time Displaying Hours - Minutes and AM/PM
Master this Excel shortcut with our comprehensive guide
Formatting Shortcuts
Ctrl + Shift + @
⌘ + Shift + @
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + @
Instructions
1. Select the cells
2. Press Ctrl + Shift + @
3. Displays time in HH:MM AM/PM format
2. Press Ctrl + Shift + @
3. Displays time in HH:MM AM/PM format
Keyboard Shortcut
⌘ + Shift + @
Instructions
1. Select the cells
2. Press Command + Shift + @
3. Displays time in HH:MM AM/PM format
2. Press Command + Shift + @
3. Displays time in HH:MM AM/PM format
💡 Pro Tip: Use for scheduling and time-tracking spreadsheets.