Calculating overtime and regular time based on shift schedule.

Hello All:

I am trying to calculate over time based on shift time.

For example: Regular shifts are between 7:00 AM to 3:00 PM (Monday thru Friday). Anything between those hours and on those days should be considered REGULAR TIME. Anything between 12:00 AM to 6:59 AM or between 3:01 PM to 11:59 PM should be calculated as OVERTIME.

Anything on Saturday or Sunday should be calculated as OVERTIME as well.


I have a few different formulas, but I can not seem to get it right. Please help!

Thank you in advance for any help.