What it's for
- Staff paid or reviewed once a month.
- Part-time and casual staff whose hours change from day to day.
- A month-end sheet for a manager or a client.
What's inside
- How to use
- Short instructions and the colour key.
- Timesheet
- Any date in the month, 31 rows that fill in their own dates (extra rows stay blank in a short month), weekends shaded, and total hours, days worked and the average on a day worked.
Preview
| Date | Start | Finish | Unpaid break | Hours |
|---|---|---|---|---|
| Mon 1 Mar 2027 | 09:00 | 17:30 | 30 min | 8.00 |
| Tue 2 Mar | 09:00 | 17:00 | 60 min | 7.00 |
| Wed 3 Mar | 08:30 | 16:30 | 30 min | 7.50 |
| Thu 4 Mar | 09:00 | 18:00 | 45 min | 8.25 |
| Fri 5 Mar | 09:00 | 13:00 | 0 min | 4.00 |
These five days total 34.75 hours over 5 days worked, an average of 6.95 hours on a day worked. March 2027 has 31 days, so all 31 rows fill in; February would leave the last three blank.
How to use it
- Type the employee, the approver and any date in the month. The sheet starts at the 1st.
- Each day you worked, type the start and finish time and any unpaid break in minutes.
- Leave days off blank. Weekends are shaded, but you can still type on them.
- Read the total hours, days worked and average under the table.
- Print the sheet, sign it and pass it on.
The formulas, explained
- 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.
Questions
Why are some rows blank at the end?
A month with fewer than 31 days leaves the extra rows empty, so the dates always belong to the month you chose.
How is this different from a fortnightly timesheet?
It has a row for every day of one calendar month rather than two weeks, shades weekends and averages the hours on days worked. It has no overtime limit.
Can I use it for a four-week period?
Not exactly. The rows follow the calendar month. Use the fortnightly template for two weeks, or two copies for four weeks.
Is the average counted over all days?
No. It is the total hours divided by the days you worked, so days off do not pull it down.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, AND, MAX, MOD, N, ISNUMBER, SUM, COUNTIF, DATE, YEAR, MONTH and WEEKDAY). It also opens in LibreOffice.
About this template
Last reviewed 15 November 2026.
Changes: 15 November 2026: first published.
Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.