Hello and thank you for any help in advance
I have a spreadsheet that is used for planning production, I want to compare
a number of start times in one column and finish times in another column to
be within a shift start and finish time as the factory runs 24 hrs.

Then return from the labour column the corresponing greater number.

This is so i am able to stop manually entering the largest labour number on
the three shifts.