Combine 3 shifts into 1 when calculating time elasped...

Hi everyone...

i encountered one major problem which hindered the process of my work.

As you can see, in the production tab, each different days are divided into 3 different shift, lunch, dinner and supper. My boss want to combine them into 1 instead which i dont know.

If you have notice, i make use of the Reference Table in the 4rd tab to calculate the block allocated for the 3 different shift.

Simple explanation of how the blocks are allocated: if you have work within the specific time of the first shift, the number of hours will be * to the block. If the worker start his work early, the difference of the time will be * to the allowance block. (if you have difficultly understanding, i can upload the matrix of how they are allocated)

The desired overview of how the worksheet look like can be found in the 2nd tab. it will be great if Reference table is used during the process.

Your help will be greatly appreciated. Thanks..
Lix