Select the cells for which you want to change the time format.
Press Ctrl + 1 or Alt + H + F + M to display the Format Cells dialog box.
Press Alt + C to select a category, use ↑ (Up Arrow key) to select a time.
Press Alt + T to select a type, use ↓ (Down Arrow key) to select a time format (ex 1:30 PM).
Press Enter. The time format has been changed.
Please send us your comments on this article.