Calculating hours that occur between certain times in a work shift

Hi!

There are several posts that are about this but I can't find one that is exactly like this, so please, can some-one help me?

i need to calculate how many hours (and minutes) fall in two different time periods (pay premiums) in a work shift.

The periods are:
18:00-24:00, i.e. the evening premium
24:00-06:00, i.e. the night premium

shifts can be:
12:00-18:00
16:00-23:00
16:00-01:00
19:00-23:00
19:00-02:00
00:00-05:30

that's to say, pretty much the shifts can span both, either or neither of these premium periods and they can also start today and end the next day.

Thanks very much to anyone who is willing to spend their time on this

Edit: the different periods are to be calculated in different cells!!

example:

work start 17:00
work end 01:30
evening premium 6
night premium 1,5



Janne