| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thank you Bob!! That worked beautifully, and i don't mind the extra column. I changed the formula in G2 to: =IF((MAX(0,F2-40))E2,E2,(MAX(0,F2-40))) to get the portion of the day spent in overtime. But that weekly tally of hours had me really confused. I'm gonna have to study that formula and figure it out. Thanks again-- kalika :) -- kalika ------------------------------------------------------------------------ kalika's Profile: http://www.excelforum.com/member.php...o&userid=26651 View this thread: http://www.excelforum.com/showthread...hreadid=399380 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for filtering and a defaulting date | Excel Worksheet Functions | |||
| MIN within range based on criteria | Excel Discussion (Misc queries) | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Threaded Mode
