Exceljet

Quick, clean, and to the point

Apply time format

Windows shortcut

CtrlShift@

Mac shortcut

⌃⇧@

Apply the Time format with the hour and minute, and indicate A.M. or P.M.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

Shortcuts for number formats

In this lesson, we cover shortcuts you can use to apply key Excel number formats: General, Number, Currency, Date, Time, and Percentage.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Brilliant work. Exceljet has quickly become my preferred source of how-tos because of the extremely clear way in which formulae are presented and explained. You've saved me so much trial-and-error time in wrangling Excel to do what I want. -Alex

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables