Sum time value within a certain time range

Hello,


I am trying to get my excel sheet to automatically count the "normal" day hours and the "evening" hours, as they have different pay values.
My question is, if there a way to get excel to calculate the two separate times, within that one shift, which crosses over from the day to evening shift.
the evening hours are from 1900 to 0700.

For example:

a shift starts at 06:00 and ends at 12:30
This shift counts 1 hour of "evening" pay and 5,5 hours of "day" pay.


shift starts at 12:00 and ends at 21:00
This shift then counts 7 hours of "day" pay and 2 hours of "evening" pay...

is there any way of doing it automatically?