Add up a timesheet in seconds with our free calculator.Open the calculator
TimeTracker
Start free
Calculator

Timesheet Calculator

Add a row for each project or day, enter the start time, end time and break, and see your week add up. You get total hours in decimal, overtime, and gross pay. No sign-up.

Project or dayStartEndBreak (min)Hours
0.00h
0.00h
0.00h
0.00h
0.00h
0.00h

Total hours this week

Hours and minutes

0h 0m

Same total, written the long way

Regular hours

0.00

Overtime 0.00 h

Hours total in decimal, so 7 hours 30 minutes is 7.50. That is the number payroll and invoices want.

Reference

Minutes to hours for a timesheet

For checking one line before it goes into the weekly total. Find the minutes and read across for hours and minutes, clock form, and decimal hours.

1 to 120 minutes1 to 120 minutes written as hours and minutes, clock time, and decimal hours.
1 to 120 minutes written as hours and minutes, clock time, and decimal hours.
MinutesIn wordsClockDecimal
1 min1 minute0:010.02
2 min2 minutes0:020.03
3 min3 minutes0:030.05
4 min4 minutes0:040.07
5 min5 minutes0:050.08
6 min6 minutes0:060.10
7 min7 minutes0:070.12
8 min8 minutes0:080.13
9 min9 minutes0:090.15
10 min10 minutes0:100.17
11 min11 minutes0:110.18
12 min12 minutes0:120.20
13 min13 minutes0:130.22
14 min14 minutes0:140.23
15 min15 minutes0:150.25
16 min16 minutes0:160.27
17 min17 minutes0:170.28
18 min18 minutes0:180.30
19 min19 minutes0:190.32
20 min20 minutes0:200.33
21 min21 minutes0:210.35
22 min22 minutes0:220.37
23 min23 minutes0:230.38
24 min24 minutes0:240.40
25 min25 minutes0:250.42
26 min26 minutes0:260.43
27 min27 minutes0:270.45
28 min28 minutes0:280.47
29 min29 minutes0:290.48
30 min30 minutes0:300.50
31 min31 minutes0:310.52
32 min32 minutes0:320.53
33 min33 minutes0:330.55
34 min34 minutes0:340.57
35 min35 minutes0:350.58
36 min36 minutes0:360.60
37 min37 minutes0:370.62
38 min38 minutes0:380.63
39 min39 minutes0:390.65
40 min40 minutes0:400.67
41 min41 minutes0:410.68
42 min42 minutes0:420.70
43 min43 minutes0:430.72
44 min44 minutes0:440.73
45 min45 minutes0:450.75
46 min46 minutes0:460.77
47 min47 minutes0:470.78
48 min48 minutes0:480.80
49 min49 minutes0:490.82
50 min50 minutes0:500.83
51 min51 minutes0:510.85
52 min52 minutes0:520.87
53 min53 minutes0:530.88
54 min54 minutes0:540.90
55 min55 minutes0:550.92
56 min56 minutes0:560.93
57 min57 minutes0:570.95
58 min58 minutes0:580.97
59 min59 minutes0:590.98
60 min1 hour1:001.00
61 min1 hour 1 minute1:011.02
62 min1 hour 2 minutes1:021.03
63 min1 hour 3 minutes1:031.05
64 min1 hour 4 minutes1:041.07
65 min1 hour 5 minutes1:051.08
66 min1 hour 6 minutes1:061.10
67 min1 hour 7 minutes1:071.12
68 min1 hour 8 minutes1:081.13
69 min1 hour 9 minutes1:091.15
70 min1 hour 10 minutes1:101.17
71 min1 hour 11 minutes1:111.18
72 min1 hour 12 minutes1:121.20
73 min1 hour 13 minutes1:131.22
74 min1 hour 14 minutes1:141.23
75 min1 hour 15 minutes1:151.25
76 min1 hour 16 minutes1:161.27
77 min1 hour 17 minutes1:171.28
78 min1 hour 18 minutes1:181.30
79 min1 hour 19 minutes1:191.32
80 min1 hour 20 minutes1:201.33
81 min1 hour 21 minutes1:211.35
82 min1 hour 22 minutes1:221.37
83 min1 hour 23 minutes1:231.38
84 min1 hour 24 minutes1:241.40
85 min1 hour 25 minutes1:251.42
86 min1 hour 26 minutes1:261.43
87 min1 hour 27 minutes1:271.45
88 min1 hour 28 minutes1:281.47
89 min1 hour 29 minutes1:291.48
90 min1 hour 30 minutes1:301.50
91 min1 hour 31 minutes1:311.52
92 min1 hour 32 minutes1:321.53
93 min1 hour 33 minutes1:331.55
94 min1 hour 34 minutes1:341.57
95 min1 hour 35 minutes1:351.58
96 min1 hour 36 minutes1:361.60
97 min1 hour 37 minutes1:371.62
98 min1 hour 38 minutes1:381.63
99 min1 hour 39 minutes1:391.65
100 min1 hour 40 minutes1:401.67
101 min1 hour 41 minutes1:411.68
102 min1 hour 42 minutes1:421.70
103 min1 hour 43 minutes1:431.72
104 min1 hour 44 minutes1:441.73
105 min1 hour 45 minutes1:451.75
106 min1 hour 46 minutes1:461.77
107 min1 hour 47 minutes1:471.78
108 min1 hour 48 minutes1:481.80
109 min1 hour 49 minutes1:491.82
110 min1 hour 50 minutes1:501.83
111 min1 hour 51 minutes1:511.85
112 min1 hour 52 minutes1:521.87
113 min1 hour 53 minutes1:531.88
114 min1 hour 54 minutes1:541.90
115 min1 hour 55 minutes1:551.92
116 min1 hour 56 minutes1:561.93
117 min1 hour 57 minutes1:571.95
118 min1 hour 58 minutes1:581.97
119 min1 hour 59 minutes1:591.98
120 min2 hours2:002.00
121 to 300 minutes121 to 300 minutes written as hours and minutes, clock time, and decimal hours.
121 to 300 minutes written as hours and minutes, clock time, and decimal hours.
MinutesIn wordsClockDecimal
125 min2 hours 5 minutes2:052.08
130 min2 hours 10 minutes2:102.17
135 min2 hours 15 minutes2:152.25
140 min2 hours 20 minutes2:202.33
145 min2 hours 25 minutes2:252.42
150 min2 hours 30 minutes2:302.50
155 min2 hours 35 minutes2:352.58
160 min2 hours 40 minutes2:402.67
165 min2 hours 45 minutes2:452.75
170 min2 hours 50 minutes2:502.83
175 min2 hours 55 minutes2:552.92
180 min3 hours3:003.00
185 min3 hours 5 minutes3:053.08
190 min3 hours 10 minutes3:103.17
195 min3 hours 15 minutes3:153.25
200 min3 hours 20 minutes3:203.33
205 min3 hours 25 minutes3:253.42
210 min3 hours 30 minutes3:303.50
215 min3 hours 35 minutes3:353.58
220 min3 hours 40 minutes3:403.67
225 min3 hours 45 minutes3:453.75
230 min3 hours 50 minutes3:503.83
235 min3 hours 55 minutes3:553.92
240 min4 hours4:004.00
245 min4 hours 5 minutes4:054.08
250 min4 hours 10 minutes4:104.17
255 min4 hours 15 minutes4:154.25
260 min4 hours 20 minutes4:204.33
265 min4 hours 25 minutes4:254.42
270 min4 hours 30 minutes4:304.50
275 min4 hours 35 minutes4:354.58
280 min4 hours 40 minutes4:404.67
285 min4 hours 45 minutes4:454.75
290 min4 hours 50 minutes4:504.83
295 min4 hours 55 minutes4:554.92
300 min5 hours5:005.00
301 to 720 minutes301 to 720 minutes written as hours and minutes, clock time, and decimal hours.
301 to 720 minutes written as hours and minutes, clock time, and decimal hours.
MinutesIn wordsClockDecimal
330 min5 hours 30 minutes5:305.50
360 min6 hours6:006.00
390 min6 hours 30 minutes6:306.50
420 min7 hours7:007.00
450 min7 hours 30 minutes7:307.50
480 min8 hours8:008.00
500 min8 hours 20 minutes8:208.33
510 min8 hours 30 minutes8:308.50
540 min9 hours9:009.00
570 min9 hours 30 minutes9:309.50
600 min10 hours10:0010.00
630 min10 hours 30 minutes10:3010.50
660 min11 hours11:0011.00
690 min11 hours 30 minutes11:3011.50
720 min12 hours12:0012.00
721 minutes and up721 minutes and up written as hours and minutes, clock time, and decimal hours.
721 minutes and up written as hours and minutes, clock time, and decimal hours.
MinutesIn wordsClockDecimal
750 min12 hours 30 minutes12:3012.50
780 min13 hours13:0013.00
810 min13 hours 30 minutes13:3013.50
840 min14 hours14:0014.00
870 min14 hours 30 minutes14:3014.50
900 min15 hours15:0015.00
930 min15 hours 30 minutes15:3015.50
960 min16 hours16:0016.00
990 min16 hours 30 minutes16:3016.50
1000 min16 hours 40 minutes16:4016.67
1020 min17 hours17:0017.00
1050 min17 hours 30 minutes17:3017.50
1080 min18 hours18:0018.00
1110 min18 hours 30 minutes18:3018.50
1140 min19 hours19:0019.00
1170 min19 hours 30 minutes19:3019.50
1200 min20 hours20:0020.00
1230 min20 hours 30 minutes20:3020.50
1260 min21 hours21:0021.00
1290 min21 hours 30 minutes21:3021.50
1320 min22 hours22:0022.00
1350 min22 hours 30 minutes22:3022.50
1380 min23 hours23:0023.00
1410 min23 hours 30 minutes23:3023.50
1440 min24 hours24:0024.00
1500 min25 hours25:0025.00
2000 min33 hours 20 minutes33:2033.33
2880 min48 hours48:0048.00
4320 min72 hours72:0072.00

Adding up a whole timesheet

One row at a time: end time minus start time, minus the unpaid break. Then add the rows. The arithmetic is easy and the mistakes are almost always in the same two places.

First, mixing formats. If some rows are 7:30 meaning seven and a half hours and others are 7.30 meaning seven hours eighteen minutes, the column total is meaningless. Pick decimal hours for the whole sheet and stay there.

Second, rounding each row before adding. Round the total once at the end, not every line. Rounding 14 daily rows to the nearest quarter hour can shift a fortnight by over an hour, and it always drifts the same way.

Weekly, biweekly, semi-monthly

Which pay period you are on decides what a full timesheet should add up to, and it is worth knowing the number so a wrong total is obvious at a glance.

Biweekly and semi-monthly are the pair people confuse, and they are genuinely different. Biweekly is every two weeks, so 26 periods and always 80 hours for full-time. Semi-monthly is twice a month, so 24 periods, and the period length changes because months do. That is why a semi-monthly timesheet can hold 88 hours one time and 80 the next.

Pay period lengths and the full-time hours each one should contain
Pay periodPeriods a yearFull-time hours
Weekly5240
Biweekly2680
Semi-monthly2486.67 average
Monthly12173.33 average

Lunches, and weeks that cross a pay period

Take unpaid breaks off each row rather than off the total, because break rules are per shift. A 30 minute unpaid meal break on a long day comes off that day even if nobody left their desk.

The awkward case is a week split across two pay periods, which happens on semi-monthly and monthly. Overtime is worked out per workweek, not per pay period, so a 45-hour week that straddles the 15th still owes 5 hours of overtime. Splitting it into two part-weeks and paying both at the base rate is a common and expensive error.

For one shift rather than a sheet, use the work hours calculator. For the overtime rules including the state daily thresholds, the overtime calculator. If you want the grid to fill in rather than a total, take the free timesheet template.

Related Free Tools

Answers

Frequently asked questions

Common queries and answers about the timesheet calculator.

How do I calculate a weekly timesheet?
Add a row per day or project, enter the start time, end time and break minutes, then read the total hours and pay at the bottom. You can add or remove rows as needed.
Does it calculate overtime and pay?
Yes. Enter an hourly rate and the weekly overtime threshold. Hours above the threshold are paid at 1.5x in the gross pay total.
Can I export the timesheet?
Yes. Download a CSV that opens in Excel or Google Sheets, with each row and the weekly total.
Is this calculator free?
Yes, completely free with no sign-up required.

Tired of doing this by hand?

TimeTracker captures every hour automatically and turns it into timesheets, invoices, and live profitability.

Start tracking free