Operations template
Timesheet Template with Hours and Pay
Log hours per day. Total hours, overtime above 40 and pay are calculated automatically.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Day | Hours |
| 2 | Mon | 8 |
| 3 | Tue | 9 |
| 4 | Wed | 8 |
| 5 | Thu | 10 |
| 6 | Fri | 8 |
| 7 | Total hours | =SUM(B2:B6) |
| 8 | Overtime | =MAX(0,B7-40) |
| 9 | Hourly rate | 250 |
| 10 | Pay | =(B7-B8)*B9+B8*B9*1.5 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B8 =MAX(0,B7-40)
Hours above 40 count as overtime.
B10 =(B7-B8)*B9+B8*B9*1.5
Regular hours at the normal rate plus overtime at 1.5x.
Make it yours by asking
Try a request like this in Tabstra:
"Create a weekly timesheet with days, hours worked, total hours, overtime above 40 hours, hourly rate and total pay"