This calculator will help you compute an estimate of overtime pay for situations where multiple rates (weighted average) or bonus-type payments (that will inflate the overtime rate) are involved. Due to rounding, the actual amount paid may be slightly different than the calculated amount on this spreadsheet.

In the spreadsheet linked below, fill in the hours and rate information, as well as the total of any bonus-type payments the employee is receiving in the given earnings period. There are comments throughout the document that will help you know what to enter, as well as explain the calculated amounts. You can see these comments by placing your mouse over a cell that has a red triangle in the top right hand corner.

Only enter in the orange sections and only enter what is earned for a 1-week period. If you have more than one week to calculate, you will need to do it separately. After you calculate for the first week, you can use the Clear button to reset the worksheet. But first, you will need to enable the macro to run.

Below are instructions on how to enable macros for Excel 2007 and prior Excel versions.

For Excel 2007:

Click on the Options button in the Security Warning section (see red arrow below).

Then select “Enable this Content” in the pop-up window and click OK. Once you do this, you will be able to click the Clear button within the spreadsheet and all the hours, rates, and amounts you entered for the first week will be cleared out so you can start fresh for the second week.

Link to the FLSA Excel 2007 worksheet

Excel Prior to 2007

You will receive the error below when you open the worksheet:

To change the security level, select Tools from the menu. Select Macro, then Security. In the Security pop-up window select the Medium radio button.

Link to the FLSA Excel 97-03 worksheet