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.

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.

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.

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