Skip to main content
ponderloop

Timesheet Calculator

To add up a timesheet, take each shift’s end time minus its start time, add 24 hours when the end is earlier than the start (an overnight shift), subtract the unpaid break, and add the days together. The example week of 6 shifts comes to 47:00 hours, which is 47.00 in decimal hours; with overtime counted over 40 hours a week, 7:00 of that is overtime, and at $22.50 an hour the gross pay is $1,136.25. Enter a start time, an end time and the unpaid break minutes for each day, in 12-hour (9:30 am, 5p) or 24-hour (17:30) time, and the calculator shows each day and the week in hours and minutes and in decimal hours. An hourly rate, an overtime option and time rounding are optional.

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. 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

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

How to calculate hours worked in a week

  1. Enter each shift. Pick the day, then type the start and end time. 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 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. 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 calculator does not model daily overtime or 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.
Is anything I type stored or sent?
No. The calculation runs in your browser and nothing you enter leaves 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

All toolsHome & DIY calculators