You can use the “Increase Decimal” button to display the total in tenths of an hour: This formula adds up all of the time increments, and then divides by 60 to return the total as a number of hours. The formula adds up all the time increments and divides by 60 to generate the number of hours:
Next, use the following formula to calculate the total time billed to the matter that day. 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): Use the following formula to calculate the length of time, in minutes, of each chunk of time spent on the matter:Įxcel defaults to a fraction of a day when it performs this calculation–the formula multiplies by 1440 to turn that into minutes.įormat the cell calculating the duration as follows to make sure it displays correctly: Set up a simple table where you’ll enter the begin time and end time for each increment of billable time:
Here’s an easy way to add up all the time on a given matter automatically. Juggling multiple matters means adding up many time increments to come up with the correct number of billable hours for each matter, each day.
0 kommentar(er)
