Time Calculations:overtime

Hi!

I want to calculate overtime which is very simple but it has become difficult according to my needs.I will be grateful if anybody can help me.

Please find the attached excel sheet to understand my requirement.


Thanks


Lovinguy

Try this:

=MAX("9:00", MOD(B2-A2, 1))-"9:00"