Hours Calculation between two times

[excel_learner]

I get an error in calculation of hours for OT calculation when I have 9:00 PM to 12:00 AM in formula. I have attached the example sheet.

Kindly assist.

[ayazgreat]

Please find attached format managed by myself if this helps you, you can change and adjust the same as per your requirment.

Ayaz

[excel_learner]

Thanks, Ayaz

[ayazgreat]

You are most welcome