Timesheet calculator

Add up a week of work hours, deduct unpaid breaks, and export a timesheet. Enter an optional hourly rate for a simple gross pay estimate in AUD.

Calculations stay in your browser. No account is required. Times, dates and pay rates are not sent in tool analytics.

Use 24-hour times, such as 09:00 or 0900. A finish earlier than the start is the next day. Equal times count as zero hours. Leave unused days blank.

Day 1
Day 2
Day 3
Day 4
Day 5
Day 6
Day 7

37h 30m equals 37.50 hours

The example week has four 09:00–17:30 shifts and one 09:00–15:00 shift, each with a 30-minute unpaid break. Total paid time is 37h 30m. At a flat $35 per hour, the gross estimate is $1,312.50. This is not an award-rate calculation.

How to use it

  1. Enter a start and finish time for each worked day. Leave unused days blank.
  2. Add unpaid breaks in minutes. Optionally enter the week starting date and one flat hourly rate.
  3. Calculate the weekly total, review overnight shifts, and download a CSV for your records.

Before you start

  • Seven consecutive days per timesheet. A finish earlier than the start is treated as the following day. Equal times mean zero hours.
  • Uses clock-time differences, without time-zone or daylight-saving adjustments. Breaks cannot exceed the shift length.
  • Gross pay uses one flat rate. It does not apply awards, overtime, penalty rates, allowances, superannuation or income tax.

Questions and answers

How are overnight shifts counted?

If the finish time is earlier than the start time, the finish is on the next day. For example, 22:00 to 06:00 with a 30-minute unpaid break is 7 hours and 30 minutes. A shift cannot represent more than 24 hours.

How do decimal hours work?

Minutes are divided by 60. Thirty minutes is 0.50 hours, so 7 hours 30 minutes is 7.50 hours, not 7.30. The calculator totals exact minutes before showing decimal hours.

Does this calculate Australian award pay?

No. The optional gross estimate multiplies total net minutes by one flat hourly rate and rounds once to cents. Check the applicable award or agreement for overtime, penalties, allowances and other entitlements.

Can I export my timesheet?

Yes. The CSV includes the entered times, unpaid breaks, overnight status, exact net minutes and decimal hours. An optional week starting date labels the seven consecutive days. Review the file before using it for payroll or invoicing.

Continue your task

Business day calculator

Count working days with Australian state holidays.

Salary calculator

Estimate Australian take-home pay using the calculator’s stated assumptions.

GST calculator

Add or remove GST for a billable amount.

Create an invoice for your billable hours

Processing notes, examples and limits reviewed by Sparksverse on .

    Timesheet calculator Free | OzSparkHub