Semi-monthly timesheet template (two periods a month)

Two pay periods a month, each on its own sheet: the 1st to the 15th and the 16th to the last day. A summary adds up each period and the month.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

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

Worked example: March 2027
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

  1. On Settings, type the employee, the approver and any date in the month.
  2. On "1st to 15th" and "16th to end", type each day's start and finish time and any unpaid break in minutes.
  3. Leave days off blank.
  4. Read the Summary: hours and days worked for each period and the month.
  5. 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.

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.