None of the QuickBooks editions do the kinds of calculations you are asking for. To do those, you need a 3rd-party calculation add-on; either FormCalc SST for QuickBooks, or CCRQInvoice. (Use Google to find their Web sites--both offer a free trial.) I work with FormCalc SST for QuickBooks.
The calculation you want to do requires a different setup than you might think, because QuickBooks forms *always* maintains this relationship: Price * Quantity = Amount. What you have to do to work around this requirement is:
(1) Make these columns which you mentioned be custom columns (defined in the Item list): Price, OT, and OT Price. (Note that Price *will not* be the Sales Price associated with an Item. Instead, you must put the Item's price--which I assume is a labor rate per hour--in a custom field; one named Price, for instance, associated with each Item.
(2) You may make Hours be the Quantity field.
(3) You won't be making any entries in QuickBooks' Rate or Price field; in fact, it will need to be hidden on printed versions of the form because it will contain a wierd looking amount when the calculations are completed.
(4) Use FormCalc SST or CCRQInvoice to do that calculations you want, putting the $$$ result in the Total column on each row. Because of the Price * Quantity = Amount (Total in your case) relationship, when the calculated Total gets assigned to that field, QuickBooks will then automatically recalculate the Rate or Price field as: Total / Quantity, which in this case is Total / Hours. But because Hours does not include OT hours, this results in the Rate or Price field containing a wierd amount as I mentioned above....which is why that field will need to be hidden on copies you provide to customers.
This really is simpler than it sounds, once you understand about QuickBooks' Price * Quantity = Amount requirement.
