Calculating an average is one of the easiest to solve problems in math. Frac V_2-V_1 V_1 frac 1 text time V 1. The formula for calculating AHT is as follows.
Multiply the average monthly payroll costs amount from Step 2 by 25.
The Average Handling Time Formula. 1 is 111900 and 112017 is 42736. The equation is now. Click on an empty cell then click on the f x symbol in the function bar above the worksheet.