sum up 3 different shifts of production for multiple part numbers (Head ache)

Hello All

MFG tab this raw data that is pasted in... This can't be a table or a pivot

JLR Report Tab – in E3 this current counts the part numbers built on 06:30 – 1430 shift, then times it by the “normal box quantity” currently 13

F3 counts items built between 14:30-22:30

G3 counts items between 22:30-06:00

Sometimes my production produces higher or lower box quantities, but this report assumes they are building in full box quantities of 13

Is there way it could sum what’s been built column E on MFG Tab, but maintain the detail for each shift

Please see attached

Paul