Excel timesheet templates

Six free .xlsx timesheets with the formulas already in place. Type your times or hours, and the totals and the billable split fill in as you go.

Download a template

Weekly timesheet

Monday to Sunday with start and end times and breaks. The dates fill in from the week's start date.

What the formulas do

Tips for using them in Excel

Other spreadsheet apps

The files are standard .xlsx, so they also open in Excel on the web, Google Sheets, Apple Numbers and LibreOffice. For Google Sheets there is also a CSV version of each template, with the steps on the Google Sheets timesheet templates page. Every template is listed on the timesheet templates page.

Hourhaven does the adding up as you track, and exports your time to CSV and Excel whenever you need a spreadsheet. It opens in January 2027, and early members keep the launch price for life.

Start your free month

Questions people ask

Is there an Excel timesheet template with formulas?

Yes, all six on this page. They work out each line's hours and the totals and, in the versions with projects, the billable and non-billable hours.

How do I calculate hours worked in Excel?

Subtract the start time from the end time and multiply by 24 to get hours, as in =(D7-C7)*24. Take off the break by subtracting its minutes divided by 60, and use MOD(D7-C7,1) instead of D7-C7 if a shift can run past midnight.

Can I protect the formulas?

Yes. The cells you type in are already unlocked, so Review, then Protect Sheet, locks only the formulas.

Do the templates contain macros?

No. They are .xlsx files, a format that can't hold macros.

Why does a cell show ####?

The column is too narrow for the number. Drag the right edge of the column header to widen it.