Juggling multiple matters means adding up many time increments to come up with the correct number of billable hours for each matter, each day. Here’s an easy way to add up all the time on a given matter automatically.
Set up a simple table where you’ll enter the begin time and end time for each increment of billable time:
Format the times as follows:
Use the following formula to calculate the length of time, in minutes, of each chunk of time spent on the matter:
Excel defaults to a fraction of a day when it performs this calculation–the formula multiplies by 1440 to turn that into minutes.
Format the cell calculating the duration as follows to make sure it displays correctly:
Now copy the formula down for all the rows in your table (one way to do this is to grab the cross-hairs at the lower right-hand corner of cell D4 (the cell with the formula) and dragging it down):
Next, use the following formula to calculate the total time billed to the matter that day. The formula adds up all the time increments and divides by 60 to generate the number of hours:
This formula adds up all of the time increments, and then divides by 60 to return the total as a number of hours.
You can use the “Increase Decimal” button to display the total in tenths of an hour:
Set up a table like this for each active matter, and you’ll be done computing your time in no time at all.
How do you keep track of your billable hours? Please share by leaving a comment below.
Follow the Excel Esquire blog to get more time-saving tips, and to learn about CLE-accredited Excel workshops. Thanks for reading!