Can't quite work out your cell refs but if your daily OT is

=max(0,dailytotal-8)

then your weekly OT is

=max(0,weeklytotal-40)

or just sum your daily OTs


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514590