Evening All,

I would like to identify how many hours appear inside a time range.

Overtime range 18:00 to 02:00

Hours worked 14:00 to 02:00 = overtime 8 hrs
Hours worked 08:00 to 22:00 = overtime 4 hrs
Hours worked 22:00 to 05:00 = overtime 4 hrs

the start time and endtime are in separate columns the hours in adj column

Regards

Baj