I am trying to create an invoice that does the following: 1) puts time entries for slips with category "court" in column A; 2) puts time entries for slips with any other category in column B; 3) applies different billable rates for the time in columns A and B, which rates are reflected by manual entry in the individual slips [this should be automatic with invoices as set up, I believe]; 4) provides a total of all time listed in Column A and a total amount of all time listed in Column B; and 4) adds together the two totals to come up with the invoice total [which also should be automatic].

Has anyone done something like this successfully? In case anyone is curious, the reason I need such an odd structure is that I do appointed legal work for my county, and they require that all invoices list the total amount of time spent in and out of court.

Any suggestions much appreciated!