Different kind of invoice
I want to do a different kind of invoice. I work in a small PR firm with a few clients. I want to track time over the month for each client and summaries it at the end with an invoice. So far I have a Projects table (which is effectively a products table) Time sheet (line Items) and an invoice sheet. However, I want it so that the invoice will group together tasks and bill for the total. for example if I spend: 5 mins on admin followed by 30mins on meetings then another 15 mins on admin, I want the invoice to total up admin so that it only reads 20mins admin and 30mins on meetings.
I hope that makes sense