Thanks Bruce, that worked quite nice.

To take this one step farther - what would I have to do if I would want
the system to automatically change the value in column D to 3 hrs if the
total of D were to calculate to below this value?

Thanks


--
rvnwdr
------------------------------------------------------------------------
rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903
View this thread: http://www.excelforum.com/showthread...hreadid=380839