Hello all. I am a novice Excel user, and cannot seem to locate the
source of my problem. Please help!


Here is my sheet:


C4 D4
E4 F4 G4 H4

9/22/2005 7:10 PM___10/1/2005 12:13 PM___ 8.7__52.6__6.0__317.64

Start date is entered into C4.
End date is entered into D4.

The following formula is in E4 to determine elapsed days:

=IF(D4=0,"",IF(C4=0,"",(IF(ISERROR((D4-C4)*24),"",(D4-C4)*24)/24)))

F4 contains "FLAGED HOURS" (for a body shop estimate)

G4 contains a value used for "cycle time" and is using the following
formula:

=IF(F4=0,"",F4/E4)

H4 contains a simple multiplication formula: =(F4*G4), but returns
317.64 INSTEAD of 315.6 (which is 52.6 x 6.0). I need the 315.6 result
in H4.

Would someone please tell me what I am doing wrong????

Thanks very much!


--
millzenator
------------------------------------------------------------------------
millzenator's Profile: http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490