Microsoft KB Archive/181217

= Subtraction Does Not Work Correctly with the HOUR Function =

Article ID: 181217

Article Last Modified on 11/26/2003

-

APPLIES TO


 * Microsoft Windows CE 2.0 for the Handheld PC
 * Microsoft Windows CE 1.0
 * Microsoft Pocket Excel 3.0
 * Microsoft Pocket Excel 2.0

-



This article was previously published under Q181217



SYMPTOMS
When you use subtraction with the HOUR function in Microsoft Pocket Excel, you may not receive the correct result.



CAUSE
This issue can occur when the result of your equation is rounded to the nearest integer. For example, this issue can occur if you use an equation similar to the following sample equation =HOUR( - ) where and are cells that contain a value.



RESOLUTION
To resolve this issue, change your equation to reduce rounding. For example, use an equation similar to the following sample equation: =HOUR-HOUR

Additional query words: 2.00

Keywords: kbprb KB181217

-

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

© Microsoft Corporation. All rights reserved.