Microsoft KB Archive/81176

= Works: Converting Time Entries to a Decimal Format =

Article ID: 81176

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 3.0 for MS-DOS
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q81176



SUMMARY
To convert a Microsoft Works for MS-DOS or Microsoft Works 4.0, 4.5, and 4.5a for Windows Spreadsheet or Database entry formatted for Time/Date into its decimal equivalent, multiply the number by 24.

For example, 9:15 A.M. can be converted to 9.25 with the appropriate formula below:

 If 9:15 A.M. is in cell A1 of a spreadsheet, use:

=A1*24

-or-

 If 9:15 A.M. is a field entry in a database, use:

='fieldname'*24

Additional query words: 1.00 2.00 3.00 4.00 4.00a 4.50 4.50a w_works wks time converting hours

Keywords: kbhowto kbui KB81176

-

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

© Microsoft Corporation. All rights reserved.