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
47:00 hours
47.00 decimal hours across 6 shifts, 7:00 of it overtime. Gross pay $1,136.25.
| Day | Hours (h:mm) | Decimal |
|---|---|---|
| Monday8:00 AM to 5:00 PM, 30 min break | 8:30 | 8.50 |
| Tuesday8:00 AM to 5:30 PM, 30 min break | 9:00 | 9.00 |
| Wednesday7:45 AM to 5:15 PM, 30 min break | 9:00 | 9.00 |
| Thursday8:00 AM to 4:30 PM, 30 min break | 8:00 | 8.00 |
| Friday9:00 AM to 6:00 PM, 30 min break | 8:30 | 8.50 |
| Saturday10:00 PM to 2:00 AM, overnight | 4:00 | 4.00 |
| Total | 47:00 | 47.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
| Typed as | Times | Unpaid lunch | Hours (h:mm) | Decimal hours | Five days |
|---|---|---|---|---|---|
| 8:30-17:00 | 8:30 AM to 5:00 PM | 30 min | 8:00 | 8.00 | 40:00 |
| 7:30-17:00 | 7:30 AM to 5:00 PM | 30 min | 9:00 | 9.00 | 45:00 |
| 8:30-17:00 | 8:30 AM to 5:00 PM | 60 min | 7:30 | 7.50 | 37:30 |
| 9:00-17:00 | 9:00 AM to 5:00 PM | 60 min | 7:00 | 7.00 | 35:00 |
| 8:00-16:30 | 8:00 AM to 4:30 PM | 30 min | 8:00 | 8.00 | 40:00 |
| 9:00-17:30 | 9:00 AM to 5:30 PM | 30 min | 8:00 | 8.00 | 40:00 |
| 7:00-15:30 | 7:00 AM to 3:30 PM | 30 min | 8:00 | 8.00 | 40:00 |
| 22:00-06:00 | 10:00 PM to 6:00 AM | 30 min | 7:30 | 7.50 | 37:30 |
The example week, day by day
| Day | Times counted | Hours (h:mm) | Decimal hours |
|---|---|---|---|
| Monday | 8:00 AM to 5:00 PM, 30 min break | 8:30 | 8.50 |
| Tuesday | 8:00 AM to 5:30 PM, 30 min break | 9:00 | 9.00 |
| Wednesday | 7:45 AM to 5:15 PM, 30 min break | 9:00 | 9.00 |
| Thursday | 8:00 AM to 4:30 PM, 30 min break | 8:00 | 8.00 |
| Friday | 9:00 AM to 6:00 PM, 30 min break | 8:30 | 8.50 |
| Saturday | 10:00 PM to 2:00 AM, overnight | 4:00 | 4.00 |
| Week | 47:00 | 47.00 |
Where the 40-hour overtime line falls
| Hours in the week | Overtime hours | Gross pay with overtime | Gross pay at the straight rate |
|---|---|---|---|
| 32:00 | 0:00 | $720.00 | $720.00 |
| 40:00 | 0:00 | $900.00 | $900.00 |
| 42:00 | 2:00 | $967.50 | $945.00 |
| 45:00 | 5:00 | $1,068.75 | $1,012.50 |
| 50:00 | 10:00 | $1,237.50 | $1,125.00 |
What each rounding choice does to a clock-in time
| Punch | Nearest 5 minutes | Nearest tenth of an hour (6 minutes) | Nearest quarter hour (15 minutes) |
|---|---|---|---|
| 8:02 AM | 8:00 AM | 8:00 AM | 8:00 AM |
| 8:03 AM | 8:05 AM | 8:06 AM | 8:00 AM |
| 8:07 AM | 8:05 AM | 8:06 AM | 8:00 AM |
| 8:08 AM | 8:10 AM | 8:06 AM | 8:15 AM |
| 8:22 AM | 8:20 AM | 8:24 AM | 8:15 AM |
| 8:23 AM | 8:25 AM | 8:24 AM | 8:30 AM |
Minutes as decimal hours
| Minutes | Decimal hours |
|---|---|
| 5 | 0.08 |
| 6 | 0.10 |
| 10 | 0.17 |
| 15 | 0.25 |
| 20 | 0.33 |
| 30 | 0.50 |
| 40 | 0.67 |
| 45 | 0.75 |
| 50 | 0.83 |
Five-day week totals by shift and unpaid lunch
| Shift | No lunch deducted | 30-minute lunch | 45-minute lunch | 60-minute lunch |
|---|---|---|---|---|
| 8:00 AM to 4:00 PM | 40:00 (40.00) | 37:30 (37.50) | 36:15 (36.25) | 35:00 (35.00) |
| 8:30 AM to 5:00 PM | 42:30 (42.50) | 40:00 (40.00) | 38:45 (38.75) | 37:30 (37.50) |
| 9:00 AM to 5:30 PM | 42:30 (42.50) | 40:00 (40.00) | 38:45 (38.75) | 37:30 (37.50) |
| 7:00 AM to 5:00 PM | 50:00 (50.00) | 47:30 (47.50) | 46:15 (46.25) | 45:00 (45.00) |
Overnight shifts that cross midnight
| Typed as | Times | Unpaid break | Hours (h:mm) | Decimal hours |
|---|---|---|---|---|
| 22:00-06:00 | 10:00 PM to 6:00 AM | None | 8:00 | 8.00 |
| 23:00-07:00 | 11:00 PM to 7:00 AM | 30 min | 7:30 | 7.50 |
| 20:00-04:30 | 8:00 PM to 4:30 AM | 30 min | 8:00 | 8.00 |
| 18:00-02:00 | 6:00 PM to 2:00 AM | 45 min | 7:15 | 7.25 |
| 21:30-05:15 | 9:30 PM to 5:15 AM | 15 min | 7:30 | 7.50 |
| 0:00-8:00 | 12:00 AM to 8:00 AM | 30 min | 7:30 | 7.50 |
Payroll rounding: part hours to tenths and quarters of an hour
| Minutes | Exact | Nearest 5 minutes | Nearest tenth (6 min) | Nearest quarter (15 min) |
|---|---|---|---|---|
| 1 | 0.02 | 0.00 | 0.00 | 0.00 |
| 3 | 0.05 | 0.08 | 0.10 | 0.00 |
| 4 | 0.07 | 0.08 | 0.10 | 0.00 |
| 7 | 0.12 | 0.08 | 0.10 | 0.00 |
| 8 | 0.13 | 0.17 | 0.10 | 0.25 |
| 10 | 0.17 | 0.17 | 0.20 | 0.25 |
| 14 | 0.23 | 0.25 | 0.20 | 0.25 |
| 15 | 0.25 | 0.25 | 0.30 | 0.25 |
| 20 | 0.33 | 0.33 | 0.30 | 0.25 |
| 22 | 0.37 | 0.33 | 0.40 | 0.25 |
| 23 | 0.38 | 0.42 | 0.40 | 0.50 |
| 30 | 0.50 | 0.50 | 0.50 | 0.50 |
| 37 | 0.62 | 0.58 | 0.60 | 0.50 |
| 38 | 0.63 | 0.67 | 0.60 | 0.75 |
| 45 | 0.75 | 0.75 | 0.80 | 0.75 |
| 52 | 0.87 | 0.83 | 0.90 | 0.75 |
| 53 | 0.88 | 0.92 | 0.90 | 1.00 |
| 59 | 0.98 | 1.00 | 1.00 | 1.00 |
One week of uneven punches under each rounding choice
| Rounding | Week total (h:mm) | Decimal hours | Overtime | Gross pay |
|---|---|---|---|---|
| No rounding (exact minutes) | 42:14 | 42.23 | 2:14 | $975.38 |
| Nearest 5 minutes | 42:20 | 42.33 | 2:20 | $978.75 |
| Nearest tenth of an hour (6 minutes) | 42:12 | 42.20 | 2:12 | $974.25 |
| Nearest quarter hour (15 minutes) | 42:45 | 42.75 | 2:45 | $992.81 |
Pay for a shift by hourly rate
| Hours worked | Decimal hours | At $15 an hour | At $18.50 an hour | At $22.50 an hour | At $30 an hour |
|---|---|---|---|---|---|
| 4:00 | 4.00 | $60.00 | $74.00 | $90.00 | $120.00 |
| 6:15 | 6.25 | $93.75 | $115.63 | $140.63 | $187.50 |
| 7:30 | 7.50 | $112.50 | $138.75 | $168.75 | $225.00 |
| 7:45 | 7.75 | $116.25 | $143.38 | $174.38 | $232.50 |
| 8:00 | 8.00 | $120.00 | $148.00 | $180.00 | $240.00 |
| 8:20 | 8.33 | $125.00 | $154.17 | $187.50 | $250.00 |
| 10:00 | 10.00 | $150.00 | $185.00 | $225.00 | $300.00 |
How to calculate hours worked in a week
- 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.
- 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.
- 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.
- 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.
- 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
- How to Add and Subtract Time: Hours, Minutes and DecimalsAdd hours and minutes by carrying 60, subtract by borrowing 60, handle midnight, and turn 7:45 into 7.75 decimal hours. Worked examples and rounding.
More free tools
- Time CalculatorAdd or subtract time from a date and clock time: what time is it 72 hours from now, or 90 minutes after 9:15? Also finds the hours between two times.
- Military Time ConverterConvert military time to standard time and back: 0730, 1430, 2.30pm, noon. Chart of every hour and half hour, how to say it, and Zulu zone letters.
- Overtime CalculatorGross pay with overtime at 1.5×, 2× or your own multiplier, from regular and overtime hours, weekly totals or a daily table with the California daily rule.
- Business Days CalculatorCount working days between two dates, or add and subtract business days from a date. Skips weekends and US federal holidays on their observed dates.
- Hourly to Salary CalculatorConvert hourly pay to salary and back across daily, weekly, biweekly, semimonthly, monthly and annual, with unpaid weeks off and overtime. Pre-tax.
- Online TimerFree online timer with alarm: run several named timers at once, quick presets, Pomodoro mode, +1 min, full screen and notifications.