Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP!! Formula with different conditions
Hi there. I'm hoping someone can help me. I'm pulling my hair out trying to
figure out how I can take a certain number of hours (for OT banking purposes) and calculating anything over 7.5 hours, up to 11 hours in one column - and anything over 11 hours in a separate column. For example: An employee worked 15 hours in a day. In the first column the formula would provide the number 3.5 (as 7.5 plus 3.5 is 11 hours for the day) and the second column would provide the number 4 (as this is the number of hours over the 11 hours). Any help that anyone could provide would be GREATLY appreciated! Thanks so much!! Teri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula with 2 conditions | Excel Discussion (Misc queries) | |||
two conditions formula | Excel Discussion (Misc queries) | |||
IF formula for 3 possible conditions | Excel Discussion (Misc queries) | |||
Formula With Several Conditions | Excel Worksheet Functions | |||
Help for a formula using two conditions | Excel Worksheet Functions |