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.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>