Hello, if anyone can tell me where I have one wrong with this I would
greatly appreciate the help! I need to sum total regular hrs for SF
then calculate where Saturdays hrs fall. Greater than 40 into weekly
ot, less than 40 into regular, and split Saturday's hrs into reg.
(based on sum of SF) and weekly OT. Here is my formula the problem
occurs in the 2nd IF, true part. $G$3 ( 40 hrs) - sum of L5:L10 (
regular hrs worked SF ). problem when weekly reg hrs are under 32.
IF(SUM(L5:L10)40,0,IF(SUM(L5:L10)<40,([b]40)-SUM(L5:L10),MIN(8,K11)))
Thank you in advance!


--
Tiesthatbind


------------------------------------------------------------------------
Tiesthatbind's Profile: http://www.excelforum.com/member.php...o&userid=32360
View this thread: http://www.excelforum.com/showthread...hreadid=521215