Pivottable data analyse

Hi there

I'm developing a run sheet and analyzing the data through Pivot Table. I'm having issue on

Pallet utilisation by trip = total pallet delivered by trip / pallet capacity
Total Working hours by day by driver = Finish time - start time

Attached sample worksheet and I would much appreciate for you any help.

Thanks

Hi,

I could do this by adding a helper column in the data sheet. See the attached file.