Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weekly reg/ot formula help please!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |