Microsoft KB Archive/263894

= Works: Any Integer Value in a Time-Formatted Column Appears As 12:00 A.M. =

Article ID: 263894

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001
 * Microsoft Works Suite 2002
 * Microsoft Works Suite 2003
 * Microsoft Works 6.0
 * Microsoft Works 7.0

-



This article was previously published under Q263894



SYMPTOMS
When you format a Microsoft Works 2000 Spreadsheet column as Time, and you then type the time as an integer, every time entry may be converted to 12:00 A.M. in that column. For example, the integer 2 becomes 12:00 A.M.

If you are using the an elapsed time format option M:S or H:M:S, and you type the time as an integer, every time entry may be converted to 0:00, or 0:00:00.



CAUSE
Time entries must always be complete, even in columns that have been formatted as Time. Incomplete time entries can cause the behavior described in the &quot;Symptoms&quot; section.



RESOLUTION
To resolve this issue, always complete a time entry. For example instead of typing 2, type 2:00 A.M. for time of day, or 2:00 for elapsed time.

Additional query words: w_works works2k

Keywords: kbprb KB263894

-

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

© Microsoft Corporation. All rights reserved.