Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Various OT Entitlement
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 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 and so forth. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Various OT Entitlement
Something as simple as
=IF(E1<=A2,0,IF(E1<=A3,0.5,IF(E1<=A4,0.75,0))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "tigermoth" wrote in message ... 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 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 and so forth. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Various OT Entitlement
or even
=LOOKUP(E1,A1:A4,{0,0.5,0.75}) which is easily extended -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "tigermoth" wrote in message ... 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 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 and so forth. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Various OT Entitlement
"Bob Phillips" wrote: or even =LOOKUP(E1,A1:A4,{0,0.5,0.75}) which is easily extended -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "tigermoth" wrote in message ... 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 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 and so forth. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|