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.