Formatting a time

To format a time:

  1. Select the Cells command from the Format menu (or right-click and select Format Cells).

  2. Select the Number tab in the "Format" dialog box.

  3. Select Time from the numbers list. The "Time" options box will be displayed.

  4. Click on the checkbox next to Seconds to display seconds as well as hours and minutes.

  5. Click on the checkbox next to 0..12 to use the 12-hour clock and thereby display a trailing AM/PM. Leave the checkbox blank to use the 24-hour clock.

See also:

Formatting a date