Daily timesheet template for Excel

An .xlsx timesheet for one day. Type the start, finish and break and the hours are worked out, then log each task and see any time not yet logged.

  • No email needed
  • .xlsx file
  • Last reviewed 15 November 2026
Download Excel (.xlsx), Daily timesheet, 9 KB

Other formats: PDF, Word · All about this template

What's in the Excel file

  • A Day sheet with employee, date, start, finish, unpaid break and hours worked.
  • 14 task lines with a start and end time, hours for each and a total.
  • A check that shows the hours worked, the hours logged to tasks and the difference, and signature lines.

How to use it in Excel

  1. Download the file. Use the download button on this page to save daily-timesheet.xlsx.
  2. Open it in Excel. Open the file. If Excel opens it in Protected View, choose Enable Editing so the formulas can calculate.
  3. Fill in the day. Type the employee, the date, the start and finish time and the unpaid break in minutes.
  4. Log the tasks. Type each task with the time it started and ended. Leave lunch out.
  5. Check and sign. Make sure hours not logged to a task is 0.00, then print the sheet and sign it.

The formulas inside

Hours worked
=IF(OR(B5="",B6=""),0,MAX(0,MOD(B6-B5,1)*24-N(B7)/60))

MOD(finish − start, 1) is the time between the two, even when the shift ends after midnight. Times 24 turns it into hours, and the unpaid break (minutes ÷ 60) comes off.

Task hours
=IF(OR(B11="",C11=""),0,MAX(0,MOD(C11-B11,1)*24))

The same calculation for each task line, without a break.

Not logged to a task
=B27-B28

Hours worked at the top minus the hours on the task lines. A negative number means the tasks add up to more than the day.

Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.

What the Excel version doesn't do

  • It covers one day. For a week use the weekly timesheet; for a month use the monthly timesheet.
  • It does not work out overtime or pay.

Questions

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive, or use File > Import in Google Sheets. It only uses functions both programs have. We do not offer a "make a copy" link, because that needs a Google account to host it.

Can I use it every day?

Save a copy for each day, or use the monthly timesheet for a row a day in one file.

Last reviewed 15 November 2026. Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.