Date range comparison

[#1]

Dear All, to get day/night working hours I'd like to compare actual working StartTime - EndTime range with 22:00 - 6:00 range e.g.

StartTime, EndTime, DayHours, NightHours

7:00, 15:00, 8, 0

5:00, 23:00, 16, 2

23:00, 7:00, 1, 7

Any idea how to compare the ranges?

BR, Przemek

[#2]

Hi prezmek,

Can you please elaborate your question. Make it clear.

thanks Joseph....

[#3]

Let's say you worked in Day1 from 21:00 to 5:30 (9pm - 5:30am) and in Day2 from 9:00 to 17:00 (9am - 5pm). So, according to day/night hours rules (day hours: 6:00-22:00, night hours: 22:00-6:00) you worked 1 day hour and 7,5 night hrs in Day1 and 8 day hours in Day2. Is this clear now?

BR, Przemek