Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add one until 171 is reached
Hello.
This is my scenario for a time sheet. If total hours worked are over 168 then each hour over is equal to comp time until 171 is reached. How can I put this into a function. Here is the set-up example: AE6 AJ6 AL6 Actual Hours Total Hours Comp Time Worked 169 169 1 There is also another caveat. If actual hours worked are less than 168, but total hours is over 168, than hours over 168 equal comp time. Scenario #2: AE6 AJ6 AL6 Actual Hours Total Hours Comp Time Worked 160 172 4 This may be too difficult or not possible to do, but any help is greatly appreciated. This is the last thing I have to do to complete the time sheet. Thanks JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a pop-up alert when a condition is reached in excel | Excel Discussion (Misc queries) | |||
How do I run a macro when a pre-determined time has been reached . | Excel Discussion (Misc queries) | |||
Counting blank cells until value is reached | Excel Worksheet Functions | |||
Autofill until blank cell is reached | Excel Discussion (Misc queries) | |||
Run recalc until a specified vaule is reached. | Excel Discussion (Misc queries) |