Example: a café’s biweekly payroll
- Ana, $18/h: 42 h and 38 h. Week 1 has 2 overtime hours. Pay: 78 × $18 + 2 × $27 = $1,458.00.
- Ben, $16.50/h: 25 h and 30 h, all regular: $907.50.
- Cara, $21/h: 46 h 30 min and 44 h, so 10.5 overtime hours. Pay: 80 × $21 + 10.5 × $31.50 = $2,010.75.
The team total is 225.5 hours, 12.5 of them overtime, and $4,376.25 gross. Ana worked exactly 80 hours in the period but is still owed 2 overtime hours, because each week is checked separately.
How the sheet works
Overtime is worked out per employee and per workweek, as the FLSA requires; two weeks can’t be averaged. Hours can be typed as decimals (38.75) or hours and minutes (38:45), but never as 38.45, which payroll would read as 38 hours 27 minutes.
For salaried non-exempt staff, enter the regular rate: weekly salary ÷ 40. Exempt staff don’t belong on an hours sheet. All figures are gross wages, before taxes and deductions, and the sheet is saved only in your browser.
Minutes to decimal hours
The common minute values, for entering time cards. For any other value, use the minutes to decimal converter.
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 3 min | 0.05 | 33 min | 0.55 |
| 6 min | 0.10 | 36 min | 0.60 |
| 9 min | 0.15 | 39 min | 0.65 |
| 12 min | 0.20 | 42 min | 0.70 |
| 15 min | 0.25 | 45 min | 0.75 |
| 18 min | 0.30 | 48 min | 0.80 |
| 21 min | 0.35 | 51 min | 0.85 |
| 24 min | 0.40 | 54 min | 0.90 |
| 27 min | 0.45 | 57 min | 0.95 |
| 30 min | 0.50 | 60 min | 1.00 |