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.