Holiday / nigh shift - time sheet computation

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.

hi it might help if you uploaded an example of your sheet

Hey, I think I can help you, however, it would be really great if you could upload the example of your sheet.
You may also contact me via customwritingz, as I am new here and I am not online all the time.

Hi guys!
Thank you for the help. I'm just figuring out how to upload my file.

thanks!

Hi Kate,
Here is the attachment.

Thank you so much!!

Hi Guys!
I still need help with the night differential computation.

I just need to segregate the ff:
1. Regular hours of the 1st day
2. Night differential of the 1st day
3. Night differential of the 2nd day
4. Regular hours of the 2nd day

Appreciate if you could help me.
Thanks!!