Hours worked (column F)
=MAX(0,MOD(D−C,1)−E/1440)
Excel Timesheet Generator
Generate a monthly Excel timesheet with one row per day, your usual hours and breaks prefilled, hours worked in hh:mm and decimal, the monthly total and optional pay.
This choice applies to every calculator; amounts are not converted.
Timesheet for the month
Choose the month and your usual hours: the XLSX workbook is built in your browser, with one row per day and editable formulas.
A real Excel workbook, not a CSV
Weekdays are prefilled. Change a time or a break in Excel and duration, decimal hours, totals and pay recalculate.
Was this tool useful?
How does this tool work?
This generator builds an Excel timesheet for any month in one click: one row per date, the weekday, start time, end time and break, then hours worked and their decimal equivalent calculated by formulas. You get a workbook to fill in as the month goes by, which you can correct row by row without ever recalculating by hand or relying on an online service: the file is created in your browser.
The workbook has one row per day of the chosen month. Monday to Friday are prefilled with your usual hours; Saturdays and Sundays stay empty unless you tick the option. Public holidays are not detected: clear the hours on those rows yourself.
Excel stores a time as a fraction of a day (12:00 is 0.5). Hours worked are therefore MOD(end − start, 1) − break / 1440: MOD keeps the difference positive when a shift ends after midnight, and the break, entered in minutes, is converted into a fraction of a day. MAX(0, …) prevents a negative result if the break is longer than the shift.
The “Hours worked” column uses the [h]:mm format, which keeps counting beyond 24 hours for the monthly total. “Decimal hours” multiplies the duration by 24 (7:30 becomes 7.5) for payroll or invoicing. If you enter an hourly rate, a pay column and its total are added, along with a summary sheet showing the name, reference and period.
How to use this tool
Choose the month and year
The current month is suggested; the file automatically has 28, 29, 30 or 31 rows.
Enter your usual hours
Start, end and break prefill the weekdays; a shift ending after midnight is accepted.
Add name, reference and rate
Optional: they appear on the summary sheet and switch on the pay calculation.
Generate the file
The .xlsx workbook is built locally and downloaded.
Complete it in Excel
Fix the days that differ, clear holidays and leave: totals recalculate.
Workbook formulas
Decimal hours (column G)
=F×24
Pay (column I)
=G×H
- C, D
- start and end times (fractions of a day)
- E
- break in minutes (1,440 minutes in a day)
- H
- hourly rate
Formulas are stored in Excel’s standard form; Excel shows them with the separators and function names of your installation.
Use cases
Log your hours every day
Note your actual start, end and break each evening; the monthly total updates itself.
Keep a record for your employer
A precise log of hours worked helps when claiming unpaid overtime.
Bill by the hour
Freelancers can use decimal hours and the hourly rate to prepare an invoice.
Track a part-time schedule
Compare actual hours with the contract each month.
Build a team template
Generate the month, add your own columns (project, site) and share the file.
Examples
October 2026, 9 am – 5 pm with a 1-hour break
October 2026 has 31 days, 9 of them Saturdays or Sundays. At €15/h, the pay column totals €2,310.
Input
Month 10 · year 2026 · 09:00 – 17:00 · break 60 minResult
22 weekdays prefilled × 7:00 = 154:00, i.e. 154.00 decimal hoursNight shift 10 pm – 6 am
Without MOD, 06:00 − 22:00 would be negative; the formula adds one day.
Input
22:00 – 06:00 · break 30 minResult
7:30 a day, i.e. 7.5 decimal hoursTips and best practices
- For a day not worked, delete the start or end time: the row is no longer counted.
- The [h]:mm total shows 154:00, not 10:00: do not switch it to hh:mm, which restarts at zero every 24 hours.
- A decimal hour is not minutes: 7.25 h is 7 h 15, not 7 h 25.
- Breaks are usually not working time; in France, for example, a break of at least 20 minutes is due after 6 hours of work. Enter the break you actually take.
- LibreOffice and Google Sheets open the file and recalculate the formulas; the date display may follow the app’s regional settings.
- This log is a record: to apply an overtime threshold and premiums, copy the weekly total into the overtime calculator.
Sources and references
- Calculate the difference between two times (opens in a new tab), Microsoft SupportPage in English
- MOD function (opens in a new tab), Microsoft SupportPage in English
- Temps de pause du salarié dans l’entreprise : quelles sont les règles ? (opens in a new tab), Service-Public.frPage in French
- Code du travail, article L3121-1 : durée du travail effectif (opens in a new tab), LégifrancePage in French
Frequently asked questions
Does the file handle night shifts?
Yes. MOD(end − start, 1) adds a day when the end time is earlier than the start time: 22:00 – 06:00 gives 8 hours before the break.
Are public holidays removed?
No, they depend on the country and the company. Simply clear the hours on those rows.
Why two duration columns?
“Hours worked” is an Excel duration readable in hours and minutes; “Decimal hours” is a number you can multiply by an hourly rate.
Can I change the hours after downloading?
Yes, every time and break cell is editable and the formulas recalculate.
Is the pay gross or net?
It is simply decimal hours × hourly rate. Premiums, bonuses, taxes and contributions are not applied.
Is my information sent anywhere?
No. The workbook is generated in your browser; the name and reference you enter never leave your device.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Similar tools
Add up the hours you worked this week, breaks deducted, in hours and minutes and in decimal hours.
Dates & timeNewUse this tool
Work out overtime above 35 hours, the +25 % and +50 % premiums of French law or your own rates, and the annual quota.
Dates & timeFranceNewUse this tool
Convert hours and minutes to decimal hours or hundredths and back.
Dates & timeNewUse this tool
Read next
GuideBest practicesBeginner
Working time: understanding hours worked, breaks and schedule calculations
Learn how to calculate actual working time, handle breaks, split shifts, midnight crossings and decimal hours.
4 October 20263 min
GuideBest practicesBeginner
Timesheets: how to track working hours in Excel
Build a useful monthly timesheet with schedules, breaks, decimal hours, totals, pay estimates and checks before payroll.
4 October 20263 min
GuideBest practicesBeginner
How to calculate work hours with a break
Calculate actual working time between a start and end time, subtract breaks and handle shifts that cross midnight.
8 September 20262 min
GuideConcepts and technologiesBeginner
Durations and time: calculate, convert and handle midnight crossings
Understand the difference between a clock time and a duration, calculate intervals between times, and convert seconds, minutes, hours, days and weeks.
28 August 20263 min