Subtraction Does Not Work Correctly with the HOUR Function

ID: Q181217

The information in this article applies to:

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          : wince handheld pocketexcel 
Version           : WINDOWS:2.0
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: April 29, 1998