Formats the selected cells as a time with hours and minutes, such as 2:30 PM. Only the display changes: Excel stores a time as a fraction of a day, so 0.5 is noon.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Apply the Date formatCtrl+Shift+3
- Open Format CellsCtrl+1
- Group rows or columnsAlt+Shift+Right
- Hide the selected columnsCtrl+0
- Hide the selected rowsCtrl+9
- Apply the Number formatCtrl+Shift+1
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply the Scientific formatCtrl+Shift+6
- Apply strikethroughCtrl+5
- Ungroup rows or columnsAlt+Shift+Left
- Unhide rowsCtrl+Shift+9