PivotTable

Hello, mathetes. Thank's a lot for your attempt to help me.

To share original spreadsheet isn't possible - this is a service document of my company, but I can share the similar copy - https://docs.google.com/spreadsheets/d/1-x7xyCXw78fsytrBN5l3Z7EnHb1E6LY6/edit?usp=sharing&ouid=117347108651710528347&rtpof=true&sd=true

The sheet list1 - original task.

The sheet list2 - my solusion - I made a separete column with words like yellow, blue, green.

The sheet PivotTable - the result from the sheet the list2.

On questions:

1. I didn't use Conditional Formatting, the colours got manually.

2. I want to sum number in columns "time of work" and "the real time of work" on the sheet list1 separately with words like white, yellow, blue and green with out separate column with words like yellow, blue, green.