What's in the Excel file
- 31 rows that fill in their own dates and stay blank past the end of a short month.
- Weekends shaded, and start, finish, unpaid break and hours for each day.
- Total hours, days worked, the average hours on a day worked and signature lines.
How to use it in Excel
- Download the file. Use the download button on this page to save monthly-timesheet.xlsx.
- Open it in Excel. Open the file. If Excel opens it in Protected View, choose Enable Editing so the formulas can calculate.
- Pick the month. Type the employee, the approver and any date in the month.
- Enter each day. Type the start and finish time and any unpaid break in minutes. Leave days off blank.
- Print and sign. Read the totals under the table, print the sheet and sign it.
The formulas inside
- Month starts
-
=IF(ISNUMBER(B5),DATE(YEAR(B5),MONTH(B5),1),"")The 1st of the month of the date you typed.
- Date
-
=IF($B$6="","",IF(MONTH($B$6+30)=MONTH($B$6),$B$6+30,""))The 1st plus the row's number of days, left blank when that lands in the next month. This is the last row.
- Hours worked
-
=IF(OR(B9="",C9=""),0,MAX(0,MOD(C9-B9,1)*24-N(D9)/60))Finish minus start, even after midnight, times 24, less the break in minutes ÷ 60.
- Average hours on a day worked
-
=IF(E42=0,0,E41/E42)Total hours divided by the days with more than 0 hours.
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
- The rows follow the calendar month, so it cannot start part-way through one. Use the fortnightly template for any two weeks.
- It has no overtime limit and does not work out 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.
What is the shading on weekends?
A formatting rule shades any row whose date is a Saturday or Sunday. You can still type on those days.
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.