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(<cell1>-<cell2>)
where <cell1> and <cell2> 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(<cell1>)-HOUR(<cell2>)
Additional query words: 2.00
Keywords: kbprb KB181217