Microsoft Office Tutorials and References
In Depth Information
Formatting Time
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.
Figure 13-1:
Using the
Cells dialog
to specify
how time
values are
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.
Search JabSto ::

Custom Search