Formatting numbers as times
- Select the range, row, or column containing the numbers you want to format.
- In the action bar, click Range.
- In the pop-up menu, click Number Format.
- Click the Category box, and then click Time.
- Click the Format box, and then click the time format you want.
- To close the pop-up panel, click
.
Time
Displays a number in the proper format as a time. If a number is not in proper time format, it displays as 12:00 AM or 00:00 in the cell.
See also
Why do I need different number formats?
Formatting numbers
Formatting numbers as currency
Formatting numbers as dates
Entering a time