Microsoft KB Archive/76986

= Works: Fill Series Using Time Formatted Values =

Article ID: 76986

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 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 &quot;Step by:&quot; 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).

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works

Keywords: kbinfo KB76986

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.