Spreadsheet Tips

Shortcut: Format a Number as a Time

February 05, 2019
An example showing the keyboard shortcut to format a number as a time.

Here's the shortcut for converting a number into a time:

Ctrl + Shift + @

(this shortcut works on both Mac and PC)

As a reminder, there are many number formatting shortcuts, all of which follow the same pattern:

  • Format as Date: Ctrl + Shift + #
  • Format as Time: Ctrl + Shift + @
  • Format as Scientific: Ctrl + Shift + ^
  • Format as Percent: Ctrl + Shift + %
  • Format as Currency: Ctrl + Shift + $
  • Format as General: Ctrl + Shift + ~

This is easy to memorize! You can format all the common number types with Ctrl + Shift + [symbol on the number row]. In most cases, the symbol matches the format intuitively ($ for currency, % for percent, etc).