**How To Calculate Overtime Formula**. You can calculate the overtime percentage for both individual employees and the overtime percentage for your entire organization using the formula: This is the formula i have used in the cell i16 to calculate the over time hours:

$100 x 5 = $500. For overtime work, your employer must pay you at least 1.5 times the hourly basic rate of pay. $500 + $150 = $650 (total) key takeaways.