Formatting numbers as times
  1. Select the range, row, or column containing the numbers you want to format.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Number Format.

  4. Click the Category box, and then click Time.

  5. Click the Format box, and then click the time format you want.

  6. To close the pop-up panel, click Pop-up panel close button.



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