Hi;

I am trying to calculate hours worked if time span fall between different time range.

Range 1 Range 2 Range 3
Start Time Finish Time Total Hours >14:00 and <16:00 >16:00 and <22:00 >22:00
08:00 14:00 6 0 0 0
08:00 15:00 7 1 0 0
08:00 18:00 10 2 2 0
10:00 17:00 7 2 1 0
10:00 23:00 13 2 6 1
12:00 02:00 14 2 6 4

I can get the total hours worked by using the MOD Function = MOD(B2-A2,1)*24 but struggling on how to calculate number of hours if finish time falls between different time range.

Any help will be much appreciated.

Thanks
Omer.