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:MajorLast Reviewed:11/26/2003
Keywords:kbprb KB181217