Microsoft KB Archive/130670

Mac Works 4.0: Incrementing a Time Series by Minutes

PSS ID Number: Q130670 Article last modified on 10-22-1998

4.0 4.0a 4.0b

MACINTOSH

======================================================================

The information in this article applies to:

• == Microsoft Works for the Macintosh, versions 4.0, 4.0a, and 4.0b ==

SUMMARY

This article describes the process for creating a column of series of times incremented by a specific number of minutes in a Works Spreadsheet.

MORE INFORMATION

1. Create a new Spreadsheet document in Microsoft Works.

2. In cell A1 type:

   0

3. In cell A2 type:

   A1+1

4. From cell A2, select cells as far down as you want to increment the data. From the Edit menu, choose Fill Down.

5. In cell B1 type the starting time using the formula “=time(HH,MM,SS)” (without the quotation marks) in military time format. For example, for 1:00 AM, you would type the following:

   =time(01,00,00)

   NOTE: You may also want to format the column of cells used to display the time. Choose Cell from the Format menu and pick Time.

6. In cell B2, type:

   =$B$1+TIME(0,MIN(A2),0)

7. From cell B2, select cells as far down as you want to increment the data. From the Edit menu, choose Fill Down.

Additional query words: kbhowto 4.00 4.00a 4.00b mac m_works minutes increments incremented increase fills filled mwksss ====================================================================== Version : 4.0 4.0a 4.0b Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.