Apple Numbers '09 - Manual (Page 96)

4 To specify how you want a date formatted, choose a format from the Date pop-up menu.
5 To specify how you want a time value formatted, choose a format from the Time pop-
up menu.
Using the Duration Format in Table Cells
Use the duration format for values that describe time increments, such as weeks, days,
hours, minutes, seconds, or milliseconds.
To define a duration format, select one or more cells, choose Duration from the
Cell Formats pop-up menu in the format bar, and use the Cells inspector to specify
the format.
To define a duration format for selected cells using the Cells inspector:
1 Select the cell or cells.
2 If the Cells inspector isn’t already open, click Inspector in the toolbar and then click the
Cells inspector button.
3 Choose Duration from the Cell Format pop-up menu.
4 Use the Units control to select the units you want to display for a duration value.
By default, hours, minutes, and seconds (h, m, and s) are displayed.
To choose a single unit, drag the left or right end of the slider toward the center until
it can get no shorter. Then click in the center of the slider and drag it over the unit you
want to use.
To choose more than one unit, resize and drag the slider until it’s over the units you
want to use.
5 From the Format pop-up menu, choose a display format.
Using the Fraction Format in Table Cells
Use the fraction format to control the display of any part of a value smaller than 1. For
example, 27.5 displays as 27 1/2 when the format is Halves and as 27 4/8 when the
format is Eighths.
96 Chapter 4 Working with Table Cells