What it's for
- Employers who pay twice a month, on set dates such as the 15th and the last day.
- Staff who want to see each pay period on its own sheet.
- Telling semi-monthly from bi-weekly: this file splits at the 15th, not every 14 days.
What's inside
- How to use
- Short instructions and the colour key.
- Settings
- Employee, approver and any date in the month.
- 1st to 15th
- 15 dated rows with start, finish and unpaid break, and the period total.
- 16th to end
- 16 dated rows, with the last rows left blank in a month shorter than 31 days, and the period total.
- Summary
- First and last day, hours and days worked for each period and for the month, with signature lines.
Preview
| Date | Start | Finish | Unpaid break | Hours | Period |
|---|---|---|---|---|---|
| Fri 12 Mar | 09:00 | 17:00 | 30 min | 7.50 | 1st to 15th |
| Mon 15 Mar | 09:00 | 17:30 | 30 min | 8.00 | 1st to 15th |
| Tue 16 Mar | 10:00 | 18:00 | 30 min | 7.50 | 16th to end |
| Wed 31 Mar | 09:00 | 17:00 | 60 min | 7.00 | 16th to end |
The first period totals 15.50 hours and the second 14.50, so the month is 30.00 hours over 4 days worked. In a 28-day February, the second period ends on the 28th and its last three rows stay blank.
How to use it
- On Settings, type the employee, the approver and any date in the month.
- On "1st to 15th" and "16th to end", type each day's start and finish time and any unpaid break in minutes.
- Leave days off blank.
- Read the Summary: hours and days worked for each period and the month.
- Print the Summary, sign it and pass it on.
The formulas, explained
- Date in the first period
-
=IF(NOT(ISNUMBER(Settings!$B$5)),"",IF(MONTH(DATE(YEAR(Settings!$B$5),MONTH(Settings!$B$5),12))=MONTH(Settings!$B$5),DATE(YEAR(Settings!$B$5),MONTH(Settings!$B$5),12),""))The date for that day number in the month you typed. DATE rolls a day that does not exist (like the 30th of February) into the next month, so the check blanks it.
- Hours worked
-
=IF(OR(B5="",C5=""),0,MAX(0,MOD(C5-B5,1)*24-N(D5)/60))Finish minus start, even after midnight, times 24, less the break in minutes รท 60.
- Last day of the second period
-
=MAX('16th to end'!A5:A20)The latest date on the second sheet. Blank rows are ignored.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
What is semi-monthly?
Pay twice a month on set dates, usually the 15th and the last day, so 24 periods a year. It is not the same as bi-weekly, which is every two weeks, usually 26 periods a year.
Do I need this or the monthly timesheet?
Use the monthly timesheet to show the month on one sheet. Use this one when each pay period has to be signed and sent on separately.
What if my periods are not the 1st to 15th?
Then the dates will not match. Use the fortnightly timesheet, which starts on any day you type, or edit the day numbers in column A.
Can Jasper HQ do semi-monthly timesheets?
No. Jasper HQ timesheets are weekly, fortnightly or monthly. For two periods a month, use a monthly timesheet and add up each half yourself.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, NOT, ISNUMBER, MAX, MOD, N, SUM, COUNTIF, DATE, YEAR and MONTH). 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.