How to fill in a time card
- Type the start and finish time for each day you worked.
- Type any unpaid break in minutes. Leave paid breaks out.
- Read each day's hours, then the weekly total at the bottom.
- 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
- All free tools
- Hours and minutes to decimal converter
- Time and a half overtime pay calculator
- Timesheet and time card calculator
- Weekly and fortnightly timesheet template
- Timesheets with approvals
Changes: 16 November 2026: first published.