I would like to make a formula stating below:
worker finishes work at 18:00,
after 18:25, we give half an hour OT
after 18:45, we give 1 hour OT
I also need to take into account some workers might work a few hours OT, therefore if he finishes work 19:25, I need excel to show 1hr30minutes OT...