Spreadsheet for legal billable hours based on multiple criteria

[Lem]

How can I build a spreadsheet that calculates billable hours for a law firm
But also take into account that other billing factors includes flat rate,percentages based on different lump-sum. In the amount to be billed
Column I would like to write a formula tha calculates only billable hours
When the work is based on hourly rate,and when it is not based on hourly rate. I would also like to have an invoice updatable for each client.

Help!!!
Thanks for your support.

 

[Trevor G]

Welcome to the forum,

Only you can determine the layout of your spreadsheet. So put some titles in it and then if you copy what you have designed you will get better responses with formula that will work.

Take a look at the templates you get as standard with Excel to see if the designs will work or at least get you started.