- Recovering More of Your Work with a Shorter AutoRecover Interval
- Automatically Saving Your Work Frequently
- Closing a Document Without Saving
- Closing All Your Open Documents
- Making Backups as You Work
- Showing More Items on the Recent Documents List
- Opening the Most Recently Used Document at Startup
- Clearing the Recent Documents List
- Creating and Opening Document Workspaces
- Automatically Prompting for Document Properties
- Creating a Trusted Location for Documents
- Viewing Total Editing Time Updated in Real-Time
- Calculating Billable Time Charges
- Locking Document Formatting
- Preventing Untracked Changes
- Setting Up a Document for Structured Editing
- Inspecting a Document for Personal Information
- Viewing Two Documents Side by Side
- Updating All Fields Automatically
This chapter is from the book
This chapter is from the book
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 A formatted formula field that calculates the billable charge based on the current EditTime result.