Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

Calculating Billable Time Charges

You saw in the previous section that you use the EditTime field to return the total editing time for a document. If you bill by the hour based on the amount of time you have worked on a document, you might want to keep track of how much money you've earned so far. If you earn, for instance, $40 per hour, the following formula displays your current billable earnings:

{ = { EDITTIME } / 60 * 40 }

The EditTime result is given in minutes, so you have to divide by 60 to get the number of hours. You then multiply that result by 40 to get the earnings.

To ensure accurate billing, you may want to use the ROUND function to round the result to the nearest dollar:

{ = ROUND( { EDITTIME } / 60 * 40, 0) \#$0.00 }

This formula field also uses a numeric format to display the result with a dollar sign and two decimal places, as shown in Figure 3.2.

Figure 3.2

Figure 3.2 A formatted formula field that calculates the billable charge based on the current EditTime result.

  • + Share This
  • 🔖 Save To Your Account