Time intersect

[PATSYS]

Hi all,

Is there a way to get the number of hours intersected by 2 time periods?

For example:

09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection)
18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs (this is from 22:00-03:00)
00:00 to 09:00 vs 21:00 to 06:00 = 6 hrs (this is from 00:00-06:00)
05:00 to 14:00 vs 21:00 to 06:00 = 1 hrs (this is from 05:00-06:00)

Thanks

 

[footoo]

Need also the dates involved because :
If this is no intersection : 09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection)
Why is this not also no intersection : 05:00 to 14:00 vs 21:00 to 06:00 = 1 hrs (this is from 05:00-06:00)

 

[PATSYS]

Need also the dates involved because :
If this is no intersection : 09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection)
Why is this not also no intersection : 05:00 to 14:00 vs 21:00 to 06:00 = 1 hrs (this is from 05:00-06:00)

It is a workshift, so date is not part of it.

Any workshift that touches on 21:00 to 06:00 gets some premium pay.

 

[footoo]

So should this be 6 hours? :
18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs

 

[PATSYS]

So should this be 6 hours? :
18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs

Yes it should be 6

The intersects are:

21:00
22:00
23:00
00:00
01:00
02:00