How to Use the Timesheet Calculator
1
Choose Time Format & Enter Work Hours
Switch between 12-hour and 24-hour format, then enter your clock-in and clock-out times.
2
Set Break Duration & Work Days
Enter the break minutes to deduct each day (e.g., lunch break) and the number of working days this week.
3
Click "Calculate" to View Results
The right panel instantly shows total duration and net work time in hours, minutes, and decimal formats.
4
Fill In the Daily Timesheet
Enter daily clock-in/out times row by row. Overtime is auto-calculated and weekends are highlighted.
5
Configure Wages, Then Export or Print
Set your hourly rate and OT multiplier in settings, then click "Export Excel" or "Print" to generate a report.
开始时间
结束时间
扣除休息
分钟
工作天数
天
暂无结果
点击「计算」查看结果
结果
总时长
00:00
以小数计
0.00 小时
以分钟计
0 分钟
净工作时间
00:00
以小数计
0.00 小时
以分钟计
0 分钟
–
已保存
| 日期 | 打卡上班 | 休息开始 | 休息结束 | 打卡下班 | 总时数 | |
|---|---|---|---|---|---|---|
| hh:mm | 小数 | |||||
|
总工资：$0
加班工资：$0
总时数：00:00
加班时数：00:00
总工时：0.00 小时
正常 0.00h · 加班 0.00h
|
||||||
四舍五入规则
选择开始日期
基本工资率和货币
$
/小时
加班在超过以下时间后计算
加班费率
乘以基本工资率
Frequently Asked Questions
How is overtime pay calculated?
Overtime pay = overtime hours × hourly rate × multiplier. You can customize the hourly wage, overtime threshold (daily or weekly), and multiplier (default 1.5×) in the settings panel.
What time formats are supported?
Both 12-hour (AM/PM) and 24-hour formats are supported. Switch between them using the toggle button at the top of the calculator or the "Use 24-hour clock" option in settings.
Is my timesheet data uploaded to a server?
No. All calculations happen locally in your browser. Data is saved in your device's localStorage and never uploaded to any server. Your information stays completely private.
How do I export my timesheet?
After filling in your timesheet, click "Export Excel" in the settings panel to download an .xls file with employee name, date range, daily details, and summary totals. Opens directly in Excel or WPS.
How many days does the timesheet support?
The timesheet shows 7 days (one week) by default. Use the date picker or Prev/Next Week buttons to navigate any week. Data is auto-saved locally — switching weeks won't lose your history.
Can I use this on mobile?
Yes. ClockCalc is fully responsive for phones and tablets. The timesheet table supports horizontal scrolling with the date column pinned to the left for easy reference.
How does the lunch break deduction work?
Enter a break start and break end time for each row — the calculator automatically subtracts that duration from the day's total work hours. For example, a 12:00–13:00 lunch break deducts exactly 1 hour. You can also enable a fixed-minute deduction in Settings under "Deduct Break Time".
Can I use this as a biweekly or monthly timesheet?
Yes. Use the Prev Week / Next Week buttons to navigate any week — each week's data is saved separately in your browser. For biweekly payroll, simply check two consecutive weeks. Excel exports include the date range in the filename so you can keep them organized.
What is the US federal overtime rate?
Under the US Fair Labor Standards Act (FLSA), non-exempt employees must receive at least 1.5× their regular hourly rate for all hours worked beyond 40 in a workweek. California additionally requires 1.5× for hours over 8 per day and 2× for hours over 12 per day.
Can I set different overtime rates for weekends and holidays?
The weekly timesheet automatically highlights weekend rows. For different rates (e.g. 2× on weekends, 3× on holidays), enter those hours separately and apply the appropriate multiplier in Settings. You can export each week to Excel and apply custom rates in the summary.
Can I use this as a free biweekly timesheet calculator with lunch break?
Yes. Fill in clock-in, clock-out, and break times for each day — the calculator deducts lunch and computes net hours automatically. For biweekly payroll, use it for two consecutive weeks and export each to Excel. The filename includes the date range so files stay organized.
Does this free timesheet calculator work for Australia?
Yes. ClockCalc supports fully customizable overtime thresholds and rates, making it suitable for any country. For Australia (Modern Award standard): set the weekly threshold to 38 hours, with 1.5× for the first 3 overtime hours and 2× beyond that. Lunch break deduction and Excel export are included.
Can IHSS workers use this as a free timesheet calculator?
Yes. IHSS (In-Home Supportive Services) workers in California are required to submit biweekly timesheets. Use ClockCalc to record daily clock-in and clock-out times, then export to Excel every two weeks for your records. The export includes daily hours and totals to help you complete your IHSS timesheet accurately.