I'm working on the man hours for my workers and need 3 separate hours. Tried a lot of formulas but none does the job. Please help.

Heres the breakdown:

Normal hours : 8am - 5pm (8Hrs - Lunch Break 1Hrs)

Normal OT :5pm - 12am (7Hrs)

Premium OT :12am - 8am (8Hrs)

Saturday from 8am - 12am is consider Normal OT

Sunday from 12am-12am(Monday) is consider Premium OT
Daily Activities AFR.xlsx