kontor suite.

Free template

Timesheet template with Excel formulas (Excel, Word, PDF)

A monthly timesheet template: enter start, end and break, and Excel works out the hours and the total. With signature fields, also as Word and PDF.

  • As Excel
  • As Word
  • As PDF

Get the template free by email

We use your email address to send you the link to the template once. You can download the files as soon as you confirm the address. See our privacy policy for details.

Privacy policy

A timesheet records when work was done on which day – for the employer, for the client or as the basis for billing by time.

In the Excel file you enter start and end for each day as clock times, the way the clock shows them, such as 8:30 and 17:00, and the break as a duration, such as 0:45 for 45 minutes. The formulas work out the hours of the row and the total for the month, in hours with decimals for billing: 8:30 to 17:00 with a 0:45 break is 7.75 hours. The Word file and the PDF have the same columns for filling in by hand, plus the signature fields.

What the template holds

  1. Details
  2. Working hours
  3. Confirmation

Frequently asked questions

How do I enter times?

The way the clock shows them, with a colon: 8:30 for the start and 17:00 for the end. Enter the break as a duration, 0:45 for 45 minutes. Excel recognises the entry as a time and calculates end minus start minus break.

Does the template calculate the hours itself?

In the Excel file, yes: every row works out its hours and the total row the breaks and hours of the whole month. The hours have decimals, the way they are billed: 7 hours 45 minutes is 7.75. In Word and the PDF you write the hours in by hand.

What do I need a timesheet for?

As a record of working time for the employer or the client, and as the basis when work is billed by time.

Is the template enough for a legal duty to record working time?

The template is not legal advice. Please clarify with your legal adviser whether and how working time has to be recorded.

Can I do this without a spreadsheet?

Kontor Suite tracks time with a timer or in a weekly grid, closes the month with an approval and turns approved hours into an invoice draft in Lexware Office. The trial is free and needs no payment details.