Counting hours worked in a range.

Unfortunately, that page does not have any info which I need. I only need to be able to count the number of hours worked between 16:00 to 08:00 from any shift.

The overtime section of my sheet is already completed (Minus an adaptation of the formula which I am currently looking for).

I don't understand how calculating the difference between two times will help me solve the problem at hand.

I have already solved this part of the problem, and can calculate the total amount of hours worked in one shift. I want to be able to find out how many hours worked in a shift fall between 16:00 and 08:00 based on the start and end times.

For example:
1) If you sign in at 04:00 and leave at 12:00, the answer will be 4.00 (4am - 8am = 4 hours).
2) If you sign in at 21:00 and out at 05:00, the answer will be 8.00 (all hours are after 16:00, and before 08:00, therefore 21:00 - 05:00 = 8 hours).

Am I looking at time intervals the wrong way?

What's the longest shift you have? This might be overkill but will cope with shifts up to 24 hours long, start time in B10, end time in B13

=MOD(B13-B10,1)-(B10>B13)*MEDIAN(0,B13-1/3,2/3)-MAX(0,MIN(1/3,B13+(B10>B13))-MAX(1/3,B10))

format as [h]:mm