Works: Fill Series Using Time Formatted Values (76986)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q76986

SUMMARY

You cannot use a standard time format (for example, 00:10:00) to do a fill series in a Works spreadsheet or database. Instead, you must use its decimal equivalent (for example, .006944444).

MORE INFORMATION

To fill a series of time values in a database or spreadsheet, you must enter the decimal value equivalent of the time in the Fill Series "Step by:" box. Works will not allow you to enter a time formatted value. The following is a table of common incremental time values and decimal equivalents.

The same results and workarounds are needed if the Fill Series - Number option is used in Works 4.0, 4.5 and 4.5a for Windows 95. 
 Time            Decimal
 Format          Format
 ------          -------

 HH:MM:SS
 00:00:01        1.15741E-05
 00:00:05        5.78704E-05
 00:00:10        0.000115741
 00:00:15        0.000173611
 00:00:30        0.000347222
 00:00:45        0.000520833
 00:01:00        0.000694444
 00:05:00        0.003472222
 00:10:00        0.006944444
 00:15:00        0.010416667
 00:30:00        0.020833333
 00:45:00        0.03125
 01:00:00        0.041666667
 05:00:00        0.208333333
 10:00:00        0.416666667
 12:00:00        0.5
If some other increment value is needed, enter the time value (for example, 00:06:00) and then change its format to general. This will give you the decimal equivalent.

Works 4.0, 4.5, and 4.5a

Works 4.0, 4.5, and 4.5a includes an AutoFill feature that allows Works to fill time as a series. Type at least the first 2 time entries, so Works knows what to use as the step value.

For example if you enter 0:10:00 in A1 and 0:20:00 in A2, select A1 and A2 and use the fill handle (at the bottom right of the selection) to drag down to subsequent cell, Works correctly places 0:30:00 in A3 (and following cells).
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB76986
©2004 Microsoft Corporation. All rights reserved.