Subtraction Does Not Work Correctly with the HOUR Function (181217)
The information in this article applies to:
- Microsoft Windows CE 2.0 for the Handheld PC
- Microsoft Windows CE for the Handheld PC, Versions 1.0
- Microsoft Pocket Excel 1.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>)
Modification Type: | Major | Last Reviewed: | 11/26/2003 |
---|
Keywords: | kbprb KB181217 |
---|
|