Microsoft Office Tutorials and References
In Depth Information
2. Click the small arrow at the bottom-right corner of the Number section.
The Format Cells dialog box appears.
3. Select Time in the Category List.
4. Select an appropriate format in the Type List.
You can display time a number of ways. Excel can format time so that hours in
a day range from 1 a.m. to 12 a.m. and then 1 p.m. to 12 p.m. Alternatively, the
hour can be between 0 and 23 with values 13 through 23 representing 1 p.m.
through 11 p.m. The latter system, known to some as military time, is
commonly used in computer systems.
Note that Excel stores a date and time together in a single serial number.
Therefore, some of the formatting options in both the time and date
categories display a complete date and time.