Microsoft KB Archive/43502

Works: Error in Time Calculations

PSS ID Number: Q43502 Article last modified on 06-10-1996

2.00

MACINTOSH

= SUMMARY =

When finding the difference between two times in a Microsoft Works spreadsheet or database, a rounding error may occur. This problem may occur because Microsoft Works represents a time as a serial number. This number is a decimal between “0” and “1”.

Works uses up to 14 decimal places to store this serial number. When calculating the difference between two times, Works rounds the decimal number to the specified number of decimal places.

For more information about time, hour, minute, and second functions, see Pages 291, 296, 302, and 304 in the “Using Microsoft Works” version 2.0 manual.

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 2.00 =

Copyright Microsoft Corporation 1996.