I am on Excel 2003 (don't guess that matters?) and the problem that I'm
seeing is:

Type 22 into I24 (using the file you uploaded)... your total (for that
day) goes to 53 in P24 (good), P29 shows 40 (which is good) but P30
shows 0 and should show the difference between the sum of the weekly
totals (P24 through P28) and P29 (40) which would be overtime and P45
shows (28).




--
ryevick
------------------------------------------------------------------------
ryevick's Profile: http://www.excelforum.com/member.php...o&userid=28882
View this thread: http://www.excelforum.com/showthread...hreadid=486316