Hi Everyone!

I’m creating a time sheet with night shift and holiday computation.
Just like a post I saw earlier, our night shift begins 10PM to 6AM.
I already got the total number of hours for regular and night shift. However, there cases for holidays where we need to separate the regular and night shift hours of the non-holiday from the holiday (regular and night shift). My marker of separation would be 12MN.

e.g.
time in: 10:00 PM
time out: 07:00 AM (Holiday)

Reg Hrs: 0
Night Shift: 2hrs (10PM - 12MN)
Night Shift (Holiday): 6 hrs (12MN - 06:00AM)
Reg (holiday): 1 hr (6AM-7AM)

Hope you guys can help me.