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.

Overtime lookup table
 

Which one is the clock out time, the one in B?
Also, does this continue with another time and 1.0 OT or are
there these 2 only (0.50 and 0.75)

If there are only 2 then you can use an IF AND formula, if there are more
you can use a VLOOKUP


Using your example create this


00:00 0
05:55 0.5
06:10 0.75



call it for instance OT_Table
then use it as

=VLOOKUP(B1,OT_Table,2)

and copy down


--
Regards,

Peo Sjoblom



"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 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.