the sheet with the formula that is getting messed up is in the same book
as the field time and shop time. each week the secratary goes in and
deletes numbers and adds numbers as needed.


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=395403