Multiply money/hours, SUM right data that has to be ''filtered'' (example in atachment)

[The excel apprentice]

Hey people,

In my sheet you can see there are 3 kind of ''fieldwork'' i added in my example sheet.
I would like for my time to be multiplied with the hours it says in each row, which then gets filtered so i can have a total of each 3 kinds of work.

So if 4jun traveltime started 6:00 - 10:00 it calculates that is 4 hours, then the 4 hours have to be multiplied with rate from traveltime somehow, so you get 4*55 in this case.

If then on 9jun there is traveltime again this time 2 hours, again the multiply in the same spot (Kolum J), and then later on added all the travel times together in the total travel time slot (yellow), same goes for workinghours and waiting time.

If possible i would also see the total time (for traveltime i made it blue).

I hope i explained my intentions sufficient.

Any tips and/or suggestions would be greatly appreciated.

Thanks in advance!

[crushdrinker06]

Please check the attached file.

[The excel apprentice]

Thanks a lot This is exactly what i meant, and i am aware of a new formula, yay!

One question though, why is it this works:

Please Login or Register  to view this content.

And this simply doesn't?

Please Login or Register  to view this content.

[crushdrinker06]

You could do

Please Login or Register  to view this content.

The reason for that is Excel does time in a decimal format. There are 24 hours in a day. Therefore 6 hours is equal to 6/24 = 0.25