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)...