Hi all,

This is my first post. I have been reading these forums for a while but luckily I have nearly always been able to find the answers to my questions without posting, however this one has me stumped.

I am trying to find how many hours additional duties add to my teams regular working hours.
For example:
Shift 1 Shift 2 Shift 3
Start Finish Start Finish Start Finish
Dan 10:30 12:00 13:00 17:30 21:00 23:30

and he has an additional duty 16:00 till 18:30.

I would like to find out how many hours total he works for the day. I.e how many hours of his additional duty fall outside of his regular working hours. (if possible without doing really complicated if(and(if(and(if(and.... etc. calculations.
I also have to loop this for 200 employees over 7 days.

Apologies if I have not explained this well but hopefully somebody will be able to help