Calculating Total Based On Cell Contents

I'd like excel to calculate 3 totals for me based on the colour and value on a worksheet.

Basically, I work for various people and they pay at different rates per hour.
I currently have a spreadsheet with their names, times, and rates (see attached for example), but I calculate the amounts paid and due manually.
If possible I would now like excel to do it.

To explain further, 'J' gives me $10 per hour, and 'V' gives me $5 per hour.
Cells shown in red show work done but not paid for.
Cells shown in green show work done and paid for.

I'd like excel to automatically create totals as shown on the spreadsheet, namely:
Total due: xxxx
Total paid: xxxx
Total outstanding: xxxx

At any time during the month I can be asked to take on more work - I would then enter the code into the spreadsheet for the hours requested...and I'd like the totals to be update automatically.