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-11-01 | Sunday | 0h | - | - | 0h | $0.00 | Sunday Rest Day |
| 2026-11-02 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-03 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-04 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-05 | Thursday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-11-06 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-07 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-11-08 | Sunday | 0h | - | 4h | 4h | $40.00 | Sunday Rest Day |
| 2026-11-09 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-10 | Tuesday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-11-11 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-12 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-13 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-14 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-11-15 | Sunday | 0h | - | - | 0h | $0.00 | Sunday Rest Day |
| 2026-11-16 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-17 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-18 | Wednesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-19 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-20 | Friday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-11-21 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-11-22 | Sunday | 0h | - | 4h | 4h | $40.00 | Sunday Rest Day |
| 2026-11-23 | Monday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-24 | Tuesday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-25 | Wednesday | 8h | 2h | - | 10h | $55.00 | - |
| 2026-11-26 | Thursday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-27 | Friday | 8h | - | - | 8h | $40.00 | - |
| 2026-11-28 | Saturday | 4h | - | - | 4h | $20.00 | Saturday Half Day |
| 2026-11-29 | Sunday | 0h | - | - | 0h | $0.00 | Sunday Rest Day |
| 2026-11-30 | Monday | 8h | 2h | - | 10h | $55.00 | - |
| GRAND TOTALS | 184 hrs | 10 hrs | 8 hrs | 202 hrs | $1075.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: