Time card calculator with breaks

Type the start and finish time for each day and the unpaid breaks. You get each day's hours and the weekly total, in hours and minutes and in decimal hours, and a CSV to download. It runs in your browser: nothing you type is sent to us.

Calculator

Rounds each start and finish time. Half a step rounds up.

Times can be typed as 9, 9am, 0900, 9:00, 17:30 or 5:30pm. Press Enter to move to the next box. Unpaid breaks are in minutes; add several with a plus, like 30+15.

Start, finish and unpaid breaks for each day of the week
Day Start Finish Unpaid breaks (min) Hours

How to fill in a time card

  1. Type the start and finish time for each day you worked.
  2. Type any unpaid break in minutes. Leave paid breaks out.
  3. Read each day's hours, then the weekly total at the bottom.
  4. Download the CSV or print the page to hand in.

Worked example. Monday 9:00 to 17:30 with a 30-minute break is 8:00. Tuesday 8:45 to 17:15 with a 30-minute break is 8:00. Wednesday 9:00 to 16:40 with no break is 7:40. Thursday 22:00 to 06:00 with a 30-minute break is 7:30. The week is 8:00 + 8:00 + 7:40 + 7:30 = 31:10, which is 31.17 decimal hours (1,870 minutes ÷ 60).

Add up in minutes and convert once at the end. Converting each day first and adding the rounded figures can drift by a few hundredths. To convert a single figure, use the hours and minutes to decimal converter.

The spreadsheet formula

In Excel or Google Sheets, with the start time in B2, the finish time in C2 and unpaid break minutes in D2, decimal hours for the day are:

=MOD(C2-B2,1)*24-D2/60

MOD(…,1) handles a shift that crosses midnight. Add the seven days with SUM.

Questions

How do I work out a weekly time card?

For each day, take the start time from the finish time, take off unpaid breaks, then add the days. 9:00 to 17:30 with a 30-minute unpaid break is 8 hours. Add the seven days for the weekly total.

What if a shift runs past midnight?

Type the start and finish as normal, for example 22:00 and 06:00. When the finish is earlier than the start, the calculator counts it as ending the next day and marks it as overnight. Put the shift on the day it started.

Do I put paid breaks in the breaks box?

No. The box is for unpaid breaks only, in minutes. A paid break is part of the shift, so leave it out. Add several unpaid breaks with a plus, like 30+15.

Can I have two shifts in one day?

This card takes one shift a day. For a split shift, enter the first start and the last finish, and put the gap between the two shifts in the unpaid breaks box. For more than that, use the timesheet calculator, which takes several shifts a day.

Does anything I type leave my browser?

No. The sums run in your browser and the card is saved only in this browser. "Clear my data" removes it.

Related

Changes: 16 November 2026: first published.

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.