Need to get total of hours within start and end times on a timesheet that qualify for shift differential.

I modified C2 to find the total number of hours worked in a shift after 11 PM & it worked!

But...I will also need to find the total number of hours worked between 3 PM and 11 PM on given days.

And the total number of hours worked between midnight and 7 AM...so the inverse of C2 where I needed to find total hours worked after 23:00, I will need the total number of hours worked prior to 7 AM.

Thank you in advance for any feedback! I have been searching for a formula such as C2 for hours.