Monthly Employee Timesheet & Overtime Tracker (Free Excel & CSV Download)
Accurate attendance and overtime tracking is essential for modern business HR and payroll management. Whether you manage a small team or a large company, tracking regular working hours (1.0x), weekday overtime (1.5x), and Sunday/holiday overtime (2.0x) ensures compliance with labour laws and prevents payroll discrepancies.
Monthly Employee Timesheet & Overtime Tracker
Customize parameters below, view live preview calculations, and download clean Excel (.xlsx) or CSV files.
| Date | Day | Standard (1.0x) | OT (1.5x) | OT (2.0x) | Total Hrs | Daily Pay ($) | Notes |
|---|---|---|---|---|---|---|---|
| 2026-09-01 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-02 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-03 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-04 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-05 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-09-06 | Sunday | 0h | - | 4h | 4h | $40.00 | Sunday Rest Day |
| 2026-09-07 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-08 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-09 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-10 | Thursday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-09-11 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-12 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-09-13 | Sunday | 0h | - | - | 0h | $0.00 | Sunday Rest Day |
| 2026-09-14 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-15 | Tuesday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-09-16 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-17 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-18 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-19 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-09-20 | Sunday | 0h | - | 4h | 4h | $40.00 | Sunday Rest Day |
| 2026-09-21 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-22 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-23 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-24 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-25 | Friday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-09-26 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-09-27 | Sunday | 0h | - | - | 0h | $0.00 | Sunday Rest Day |
| 2026-09-28 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-29 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-09-30 | Wednesday | 8h | 2h | - | 10h | $55.00 | - |
| GRAND TOTALS | 192 hrs | 8 hrs | 8 hrs | 208 hrs | $1100.00 | ||
1Understanding Overtime Rates & Multipliers
Standard labour regulations in Cambodia and most international jurisdictions define standard working hours as 8 hours per day (48 hours per week). Any work performed beyond standard daily hours or on weekly rest days is classified as Overtime (OT) and requires higher pay multipliers:
Standard Work Hours
Regular Monday–Friday or Monday–Saturday shifts up to 8 hours daily. Paid at 100% standard hourly wage.
Regular Weekday Overtime
Additional hours worked after normal daily 8 hours on regular workdays. Paid at 150% of base hourly wage.
Sunday & Public Holiday OT
Work performed on weekly rest days (Sundays) or official public holidays. Paid at 200% of base hourly wage.
2Key Formulas to Use in Microsoft Excel & Google Sheets
When building your own timesheet in Excel or Google Sheets, use these essential formulas to calculate hours and earnings automatically:
3Related Free HR & Payroll Utilities on ToolKH
Combine your timesheet tracking with our online web utilities for instant online calculations: