Download
Weekly timesheet (Excel) Monthly timesheet (Excel)
Format .xlsx, opens in Excel 2010 or later, LibreOffice Calc, Google Sheets (upload the file) and Numbers. No macros, no sign-up.
What the templates contain
| Column | Content | Formula |
|---|---|---|
| Date, Day | Derived from the Monday or first of the month you enter | automatic |
| Start, End | Clock times such as 8:00 AM and 5:00 PM; overnight shifts allowed | input |
| Break | Hours:minutes, for example 0:30 | input |
| Hours worked | End minus start minus break, corrected across midnight | =IF(End<Start, End+1−Start, End−Start)−Break |
| Decimal | Hours worked as decimal hours, two places | =ROUND(Hours×24,2) |
| Target | Weekly target divided by 5, or the daily target on weekdays | automatic |
| Balance | Decimal minus target, totalled at the bottom | =Decimal−Target |
| Note | Vacation, sick, holiday, project | input |
The totals row adds breaks and hours in [h]:mm format so that totals above 24 hours display correctly. Signature lines for employee and employer and a recordkeeping note (29 CFR 516.2) sit below the table.
How to use the template
- Enter name, employer and period at the top; in the weekly template the Monday date, in the monthly template the first of the month. The days fill in automatically.
- Adjust the weekly target (default 40) or daily target (default 8).
- Enter start, end and break per day. Note vacation or sick days in the Note column; to credit them, enter the target as hours or set that day's target to 0.
- Printing: the print area fits one Letter or A4 page. Choose "Save as PDF" in the print dialog for a PDF.
Prefer not to use Excel? The online time card calculator applies overtime rules and holidays automatically and exports PDF or CSV.
What a timesheet must record
Under the FLSA (29 CFR 516.2) employers must keep, for each non-exempt employee, the hours worked each day and the total hours each workweek; time cards are kept for two years and payroll records for three. No particular form is required, so a spreadsheet is acceptable as long as it is complete and accurate. The templates add breaks, target and balance on top of the required fields. Rounding, if used, must follow 29 CFR 785.48; see the 7-minute rule guide.
Frequently asked questions
Is the template really free?
Yes. Both files download without sign-up and may be used freely, including in a business. A small credit to calchours.com sits below the table; you may remove it.
Why does Excel show the wrong total time?
If you format cells yourself, use the [h]:mm format with square brackets for totals. Without the brackets Excel wraps around after 24 hours. The templates are already formatted this way.
How do I enter an overnight shift?
Start 10:00 PM, end 6:00 AM: the formula detects that the end is before the start and adds one day, giving 8:00 minus the break.
Can I use it in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets; formulas and time formats carry over. Date formats may differ depending on your locale settings.
How are minutes converted to decimal hours?
The Decimal column does it: minutes divided by 60, so 7:45 becomes 7.75 hours. A chart for every minute is on the hours to decimal page.
Related calculators
- Time Card Calculator with Lunch and OvertimeFill in clock-in, clock-out and lunch for each day of a weekly or biweekly pay period. The time card totals hours in hh:mm and decimal, splits regular and overtime hours, and can be printed or exported.
- Hours to Decimal Calculator and Minutes to Decimal ChartEnter a time in hours and minutes to get decimal hours, or enter decimal hours to get hours and minutes. The chart below lists every minute from 1 to 60.
- The 7-Minute Rule and Time Clock RoundingEnter a punch time above to see how it rounds under quarter-hour, tenth-hour and 5-minute rounding, and compare the rounded result with the exact minutes.
- Work Hours CalculatorEnter your start time, end time and unpaid breaks to get hours worked for a day, a week or a pay period in hh:mm and decimal hours. Overnight shifts, overtime and pay are handled automatically.