Penalty period within timesheet

[Patchcord]

I have a time period everyday from 23:00 - 0400 where an extra shift penalty applies.

I have 8-12 hour shifts that commence before 23:00 and after 23:00.

Is there a way to calculate the number penalty hours that are worked during a shift.

I'd be very grateful for any assistance!

 

[Patchcord]

Did some more searching and found my answer here:

http://www.mrexcel.com/forum/showthread.php?p=638787

Thanks for the valuable resource!!