| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Overtime lookup table
How do I create the followings :
Column A1 5.45pm B1 5.54 pm C1 0 A2 5.55 pm B2 6.09 pm C2 0.5 If an employee clocks out between at 5.45 and 5.54pm he is not entitle to any OT. But if he clocks out between 5.55 and 6.09pm, he is entitle to 0.5 hour OT. If he clocks out between 6.10 and 6.24pm is entitle to 0.75 hour OT. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 | Excel Worksheet Functions | |||
| Lookup table | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| Help with lookup table | Excel Worksheet Functions | |||
| Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
