How to sum times by matching in a table?

[PistachioPedro]

Hi! First time here in a long time.

Hopefully somebody can help me out with with this.

I am trying to calculate the sum of times by matching a license plate in a table.

As you can see column J is the result I want, by matching column I with C and returning the the sum of values in column G that match.
Hope that all makes sense.

Any help would be hugely appreciated!
Thanks

[Phuocam]

Channge G2 to:= F2-E2 and Format Cells as [h]:mm

Copy C2 paste I2

in J2:

=SUMIF($C$2:$C$4,I2,$G$2:$G$4)

[kersplash]

I solved using a pivot table.

Also changed the Time field to be a number rather than text.

[FlameRetired]

Also change 1HK 35Z to 1HK 3SZ in cell I2.