Skip to main content
ponderloop

Timesheet Calculator

8:30-17:00 with a 30-minute unpaid lunch is 8:00 hours (8.00 decimal hours). The example week of 6 shifts comes to 47:00 hours (47.00 decimal), 7:00 of it overtime over 40, and gross pay is $1,136.25 at $22.50 an hour.

Updated Runs in your browser: nothing you enter is uploadedHow this tool works

One row per shift. Type times like 9:30 am, 5p or 17:30, or a whole shift like 8:30-17:00 in Start. If the end is earlier than the start, the shift runs past midnight.

47:00 hours

47.00 decimal hours across 6 shifts, 7:00 of it overtime. Gross pay $1,136.25.

Hours worked each day
DayHours (h:mm)Decimal
Monday8:00 AM to 5:00 PM, 30 min break8:308.50
Tuesday8:00 AM to 5:30 PM, 30 min break9:009.00
Wednesday7:45 AM to 5:15 PM, 30 min break9:009.00
Thursday8:00 AM to 4:30 PM, 30 min break8:008.00
Friday9:00 AM to 6:00 PM, 30 min break8:308.50
Saturday10:00 PM to 2:00 AM, overnight4:004.00
Total47:0047.00
Total hours (h:mm)
47:00
Total decimal hours
47.00
Regular hours (up to 40)
40:00 (40.00 h)
Overtime hours (over 40)
7:00 (7.00 h)
Regular pay
$900.00
Overtime pay (1.5×)
$236.25
Gross pay
$1,136.25

Worked examples: typical shifts with an unpaid lunch

Each shift typed as one range in the Start box, with the lunch in the Break box. The last column is five such days.
Typed asTimesUnpaid lunchHours (h:mm)Decimal hoursFive days
8:30-17:008:30 AM to 5:00 PM30 min8:008.0040:00
7:30-17:007:30 AM to 5:00 PM30 min9:009.0045:00
8:30-17:008:30 AM to 5:00 PM60 min7:307.5037:30
9:00-17:009:00 AM to 5:00 PM60 min7:007.0035:00
8:00-16:308:00 AM to 4:30 PM30 min8:008.0040:00
9:00-17:309:00 AM to 5:30 PM30 min8:008.0040:00
7:00-15:307:00 AM to 3:30 PM30 min8:008.0040:00
22:00-06:0010:00 PM to 6:00 AM30 min7:307.5037:30

The example week, day by day

Hours worked each day in the example, with overtime counted over 40 hours.
DayTimes countedHours (h:mm)Decimal hours
Monday8:00 AM to 5:00 PM, 30 min break8:308.50
Tuesday8:00 AM to 5:30 PM, 30 min break9:009.00
Wednesday7:45 AM to 5:15 PM, 30 min break9:009.00
Thursday8:00 AM to 4:30 PM, 30 min break8:008.00
Friday9:00 AM to 6:00 PM, 30 min break8:308.50
Saturday10:00 PM to 2:00 AM, overnight4:004.00
Week47:0047.00

Where the 40-hour overtime line falls

Gross pay for a week at $22.50 an hour, with and without overtime over 40 hours at 1.5 times the rate.
Hours in the weekOvertime hoursGross pay with overtimeGross pay at the straight rate
32:000:00$720.00$720.00
40:000:00$900.00$900.00
42:002:00$967.50$945.00
45:005:00$1,068.75$1,012.50
50:0010:00$1,237.50$1,125.00

What each rounding choice does to a clock-in time

Each start or end time is moved to the nearest multiple of the chosen step; an exact halfway time rounds up.
PunchNearest 5 minutesNearest tenth of an hour (6 minutes)Nearest quarter hour (15 minutes)
8:02 AM8:00 AM8:00 AM8:00 AM
8:03 AM8:05 AM8:06 AM8:00 AM
8:07 AM8:05 AM8:06 AM8:00 AM
8:08 AM8:10 AM8:06 AM8:15 AM
8:22 AM8:20 AM8:24 AM8:15 AM
8:23 AM8:25 AM8:24 AM8:30 AM

Minutes as decimal hours

Payroll often wants hours as a decimal: divide the minutes by 60.
MinutesDecimal hours
50.08
60.10
100.17
150.25
200.33
300.50
400.67
450.75
500.83

Five-day week totals by shift and unpaid lunch

Each cell is five identical days of the shift in the row, less the lunch in the column, in h:mm and as decimal hours. A shift typed as one range, no overtime or pay.
ShiftNo lunch deducted30-minute lunch45-minute lunch60-minute lunch
8:00 AM to 4:00 PM40:00 (40.00)37:30 (37.50)36:15 (36.25)35:00 (35.00)
8:30 AM to 5:00 PM42:30 (42.50)40:00 (40.00)38:45 (38.75)37:30 (37.50)
9:00 AM to 5:30 PM42:30 (42.50)40:00 (40.00)38:45 (38.75)37:30 (37.50)
7:00 AM to 5:00 PM50:00 (50.00)47:30 (47.50)46:15 (46.25)45:00 (45.00)

Overnight shifts that cross midnight

When the end time is earlier than the start, the shift runs into the next day. Each row is worked out by the calculator from the range typed in the Start box and the break in minutes.
Typed asTimesUnpaid breakHours (h:mm)Decimal hours
22:00-06:0010:00 PM to 6:00 AMNone8:008.00
23:00-07:0011:00 PM to 7:00 AM30 min7:307.50
20:00-04:308:00 PM to 4:30 AM30 min8:008.00
18:00-02:006:00 PM to 2:00 AM45 min7:157.25
21:30-05:159:30 PM to 5:15 AM15 min7:307.50
0:00-8:0012:00 AM to 8:00 AM30 min7:307.50

Payroll rounding: part hours to tenths and quarters of an hour

Minutes past the hour as decimal hours, exactly (two decimals) and after rounding to the nearest 5 minutes, tenth of an hour (6 minutes) or quarter hour (15 minutes). Exact halves round up. The calculator rounds each start and end time rather than a finished duration, so a table of durations is a guide to the principle only.
MinutesExactNearest 5 minutesNearest tenth (6 min)Nearest quarter (15 min)
10.020.000.000.00
30.050.080.100.00
40.070.080.100.00
70.120.080.100.00
80.130.170.100.25
100.170.170.200.25
140.230.250.200.25
150.250.250.300.25
200.330.330.300.25
220.370.330.400.25
230.380.420.400.50
300.500.500.500.50
370.620.580.600.50
380.630.670.600.75
450.750.750.800.75
520.870.830.900.75
530.880.920.901.00
590.981.001.001.00

One week of uneven punches under each rounding choice

Five days punched at 8:04 am to 5:02 pm, 7:52 am to 4:58 pm, 8:08 am to 5:09 pm, 8:21 am to 4:44 pm, 8:07 am to 5:23 pm, each with a 30-minute unpaid break, at $22.50 an hour. The calculator rounds each start and end time before the hours are added.
RoundingWeek total (h:mm)Decimal hoursOvertimeGross pay
No rounding (exact minutes)42:1442.232:14$975.38
Nearest 5 minutes42:2042.332:20$978.75
Nearest tenth of an hour (6 minutes)42:1242.202:12$974.25
Nearest quarter hour (15 minutes)42:4542.752:45$992.81

Pay for a shift by hourly rate

Straight-time pay for the hours worked, before overtime, tax or deductions: decimal hours times the rate, rounded to the cent.
Hours workedDecimal hoursAt $15 an hourAt $18.50 an hourAt $22.50 an hourAt $30 an hour
4:004.00$60.00$74.00$90.00$120.00
6:156.25$93.75$115.63$140.63$187.50
7:307.50$112.50$138.75$168.75$225.00
7:457.75$116.25$143.38$174.38$232.50
8:008.00$120.00$148.00$180.00$240.00
8:208.33$125.00$154.17$187.50$250.00
10:0010.00$150.00$185.00$225.00$300.00

How to calculate hours worked in a week

  1. Enter each shift. Pick the day, then type the start and end time, or the whole shift as one range such as 8:30-17:00 in the Start box. Both 12-hour times (8:00 am, 5p) and 24-hour times (17:30) work. The example’s first row is Monday 8:00 AM to 5:00 PM, 30 min break.
  2. Add the unpaid break. Type the unpaid break in whole minutes. It is taken off that shift: 8:00 am to 5:00 pm is 9:00 on the clock, and a 30-minute break leaves 8:30.
  3. Let overnight shifts cross midnight. When the end is earlier than the start, the shift runs into the next day. 10:00 pm to 6:00 am with a 30-minute break is 7:30 (7.50 decimal hours). The example’s Saturday shift, 10:00 PM to 2:00 AM, overnight, counts 4:00.
  4. Add more days or remove one. Press Add row for another shift, including a second shift on the same day. Remove deletes a row. A row with no times is left out of the total.
  5. Add a rate, overtime and rounding if you want them. With an hourly rate of $22.50 the calculator shows gross pay. Tick the overtime box to pay hours over 40 in the week at 1.5 times the rate: the example’s 47:00 hours become 40:00 regular and 7:00 overtime, $1,136.25 in all, against $1,057.50 with no overtime.

Frequently asked questions

How do I calculate hours worked from start and end times?
Subtract the start time from the end time, then subtract any unpaid break. 8:00 am to 5:00 pm is 9 hours on the clock; with a 30-minute unpaid break it is 8:30, or 8.50 in decimal hours. Do that for each day and add the days. The calculator does it as you type.
How many hours is 8:30-17:00 with a lunch break?
With a 30-minute unpaid lunch it is 8:00 (8.00 decimal hours); with an hour for lunch it is 7:30. A 7:30-17:00 shift with a 30-minute lunch is 9:00. The table above lists more.
How are overnight shifts calculated?
If the end time is earlier than the start time, the calculator treats the end as the next morning and adds 24 hours before subtracting the start. 10:00 pm to 6:00 am is 8 hours, and 7:30 after a 30-minute break. The whole shift is counted on the day it started. An end time equal to the start time counts as 0 hours, not 24.
What time formats can I type?
Both 12-hour and 24-hour times: 9:30 am, 9:30am, 9a, 5p, 5:15 p.m., 17:30, 1730, noon and midnight. You can also type a whole shift as one range in the Start box and leave End empty: 8:30-17:00, 8:30 - 17:00 or 9am to 5pm. A time with no AM or PM is read as 24-hour time, so 5:00 means 05:00, not 5 pm. The calculator says so under the result when that happens, and warns about a very long shift, because a missing PM is the usual cause. The time reading is the same one the military time converter uses.
How do I convert hours and minutes to decimal hours?
Divide the minutes by 60 and add them to the hours. 8:30 is 8 + 30/60 = 8.50. 47:00 is 47.00. A quarter hour is 0.25, 20 minutes is 0.33 and 10 minutes is 0.17. The calculator shows both forms, to two decimals.
How is overtime calculated?
Under the federal Fair Labor Standards Act (FLSA), covered employees who are not exempt must be paid at least one and one-half times their regular rate for hours worked over 40 in a workweek. Tick the overtime box and the calculator pays the first 40 hours at the rate and the rest at 1.5 times it. In the example, 40:00 regular hours at $22.50 is $900.00 and 7:00 overtime at $33.75 is $236.25, for $1,136.25.
Does overtime depend on the day or only on the week?
Under the federal rule it is the workweek, a fixed, regularly recurring period of 168 hours (seven 24-hour days), and hours are not averaged across two weeks. Working a Saturday or a holiday does not by itself create overtime under the FLSA. Some states, California among them, also require overtime for hours over a set number in a single day, and have extra rules for a seventh consecutive day. This timesheet counts hours over 40 for the week you enter, not hours over a daily limit, and does not model any other state rule, so in those states treat its overtime figure as the weekly part only.
Is the gross pay exact?
It is the straight-time and overtime pay for the hours shown, to the cent, before any tax or deduction. It uses only the hourly rate you enter. Bonuses, shift differentials and other pay that federal law counts in the regular rate are not included, and neither are salaried or exempt pay arrangements.
Can an employer round my time?
The federal rule is 29 CFR 785.48(b). It says that recording starting and stopping time to the nearest 5 minutes, one-tenth of an hour or quarter hour has been an accepted practice in some industries, and that the Department of Labor accepts it for enforcement purposes as long as it averages out over time, so that employees are fully compensated for all the time they actually work. Rounding that always goes the employer’s way, or that leaves workers short over time, does not meet that test. The rule is about the principle; whether a particular policy meets it is a question for the facts, and some states set their own rules. This tool just lets you see the effect of each choice on your hours.
How does the rounding option work?
The calculator rounds each start time and each end time to the nearest 5, 6 (a tenth of an hour) or 15 minutes, with exact halves going up, and counts the time between the rounded punches. The break is not rounded. With 15-minute rounding the example week is 47:00 (47.00) instead of 47:00; when a rounding choice changes the total, the exact total is shown beside it so you can compare.
How do I enter a split shift or two shifts in one day?
Add a row and pick the same day again. Each row is counted separately and all of them go into the week. Use the unpaid break box for a break inside one shift, and a second row when you clock out and back in.
What is the difference between 7:45 and 7.45 hours?
They are different amounts of time. 7:45 means 7 hours 45 minutes, which is 7.75 decimal hours. 7.45 hours is 7 hours and 0.45 × 60 = 27 minutes, which is 7:27. Typing minutes after the decimal point is one of the most common timesheet mistakes, so convert by dividing the minutes by 60 first.
How do I work out pay for hours and minutes?
Convert to decimal hours, then multiply by the rate. 37:45 is 37.75 hours, and at $18 an hour that is $679.50. Multiplying 37.45 by the rate instead would under-pay, because 45 minutes is 0.75 of an hour, not 0.45.
How much does rounding change a week?
It depends on the punches, and it can go either way. A week of uneven punches (the table above) is 42:14 with exact minutes, 42:20 rounded to 5 minutes, 42:12 to a tenth of an hour and 42:45 to a quarter hour, and the gross pay moves from $975.38 to $992.81. The effect depends on which side of the rounding points the actual punches fall on. The example week above is unchanged by rounding because every punch is already on a quarter hour.
How do I enter a shift that starts at midnight or ends at midnight?
Type midnight as 0:00 or 12:00 am. When the end is earlier than the start the shift crosses midnight, so 22:00-0:00 is 2:00, and a shift that starts at midnight works the same way: 0:00-8:00 with a 30-minute break is 7:30. An end equal to the start counts as 0 hours, so for a full 24 hours enter two rows instead.
Should a paid break be entered in the break box?
No. The break box is only for time that is taken off, so a break you are paid for stays in the shift and the box is left empty or at 0. If your lunch is unpaid, enter its length in minutes. Whether a break is paid is set by your employer and the rules where you work, which the calculator cannot know.
How do I total hours over a fortnight or a month?
Enter the days in the rows and read the week total, then add the weekly totals as h:mm. Add the hours and the minutes separately and carry every 60 minutes into an hour, so 38:45 and 41:30 make 80:15. The calculator holds up to 14 rows, which covers two weeks at one shift a day, but it treats all rows as a single week for the overtime line.
Is anything I type stored or sent?
No. Your start and end times, breaks and pay rate are totalled by the page in your browser, so the times you type are never sent to a server and never leave your device.

How it works

Each time is read as minutes after midnight with the same tolerant reader the military time converter uses, so 12-hour and 24-hour spellings give the same result, plus one-letter AM and PM (5p, 9a). A shift is the end minus the start; when the end is earlier than the start, 24 hours are added first, so the shift crosses midnight, and the same start and end counts as 0. The unpaid break, in whole minutes, is subtracted. A break longer than the shift is reported rather than counted, and so is a row with only one of its two times. Rows with no times are skipped. If rounding is chosen, the start and the end are each moved to the nearest multiple of 5, 6 or 15 minutes (exact halves round up) before the subtraction, the way a time clock rounds punches; the break and the pay are not rounded separately. The week is the sum of the rows, in whole minutes. Decimal hours are minutes divided by 60, shown to two decimals. With overtime on, minutes beyond 2,400 (40 hours) in the week are overtime, paid at 1.5 times the hourly rate; the rest is paid at the rate. Pay is worked out from the exact rate in whole cents and rounded to the cent once per line, half up, so regular pay plus overtime pay is the gross pay. The rows are treated as one workweek. The tool does not model daily overtime, seventh-day rules, double time, exemptions, tax or any state rule, and nothing here is legal or payroll advice. Everything runs in your browser and nothing you type is sent anywhere.

Sources

Guides

All dates & timeAll toolsHome & DIY calculators