↑↓ to move · Enter to open · Esc to close
Calculate hours on a timesheet from clock-in to clock-out

Calculate hours on a timesheet from clock-in to clock-out

Clock-in and clock-out times become a count of hours after unpaid breaks come out and a shift past midnight is counted forward. A schedule that repeats every day is a different sum from a week of uneven days.

calculate hours on a timesheet Updated

Minutes written as a decimal, and a shift that crosses midnight

A timesheet stores clock times. Payroll and invoices often want those hours as a decimal. Eight hours and 25 minutes is 8 plus 25 divided by 60, which is 8.4167 hours. Writing 8:25 as 8.25 records 8 hours and 15 minutes, so that line is 10 minutes short. Fifteen minutes is 0.25 of an hour, thirty is 0.5, and forty-five is 0.75. Twenty minutes is 0.3333 and forty is 0.6667.

A shift that ends earlier on the clock than it started has crossed midnight. Subtracting the start from the end without adding 24 hours produces a negative span, so the day looks shorter than it was. The same start and end, with no dates attached, comes out as zero hours and misses a shift that lasted a full day. These are wall-clock times with no time zone. A daylight-saving change inside the range is ignored, and the real elapsed time on those nights can be an hour more or less.

A week where every day matches can be multiplied out to a month and a year. A week where Monday was short and Thursday ran late has to be added day by day. A 40-hour week is 40 times 52, or 2,080 hours in a year, and that figure still includes vacation and public holidays unless you take them off. Overtime is the hours past a threshold. A weekly threshold and a daily threshold can both apply to the same hour. Adding those two piles pays that hour twice. Gross pay is hours times a rate. Tax and other deductions come off later. Overtime rules differ by place and employer, so the gross line from a calculator is an estimate.

One span, then a repeating day, then the uneven week

When you have two clock times and you need the length, use the Time Duration Calculator. Enter the start and the end. The form can show 12-hour or 24-hour times. If the end is earlier than the start, 24 hours are added and the result is marked Overnight. If the range covers more than one day, tick Different dates and fill both dates. You get hours and minutes, decimal hours to 4 places, and the total in minutes. On that page, 09:15 to 17:40 is 8 h 25 m (8.4167 hours, 505 minutes). 22:30 to 06:15 is 7 h 45 m overnight (7.75 hours, 465 minutes). From 2026-09-25 08:00 to 2026-09-27 20:00 is 60 h 0 m. The same start and end without dates gives 0, not 24 hours. For a full day, turn Different dates on. With dates, an end that falls before the start is an error, and Swap reverses the two points.

When every working day has the same start, end, and unpaid break, use the Work Hours Calculator. Enter the start, the end, the break in minutes, and how many days you work in a week, from 1 to 7. An end earlier than the start is an overnight shift. The day is that span minus the break. The week is the day multiplied by the number of days. The year is the week multiplied by 52. The month is the week multiplied by 52 and divided by 12, because months are not the same length and this is an average month. One example on the page: 08:30 to 17:00 with a 45-minute break, 5 days a week, is 7 h 45 m per day (7.75 hours), 38.75 hours a week, 167.92 hours in an average month, and 2,015 hours a year. 22:00 to 06:00 with a 30-minute break is 7 h 30 m per day. A 40-hour week is 173.33 hours in an average month and 2,080 hours a year. A 35-hour week is 151.67 and 1,820. A 37.5-hour week is 162.5 and 1,950. Those yearly figures do not subtract vacation or public holidays. A break as long as the shift, or longer, is an error. If the hours change from day to day, this calculator assumes they do not.

For a week of different days, a split shift, overtime, or a pay line, use the Time Card Calculator. Each day has a clock-in, a clock-out, and an unpaid break in minutes. Add shift adds another row on the same day. Leave days off empty. An empty day counts as 0 hours. A clock-out earlier than the clock-in means the shift ran past midnight. The day is the sum of its shifts minus the break. A break longer than the shift is an error on that day. Overtime is the hours past the weekly threshold. The default threshold is 40 hours and the default multiplier is 1.5. If you also set a daily overtime threshold, daily and weekly overtime are worked out separately and the larger of the two is kept. Those hours are not counted as overtime twice. Rounding, when you turn it on, moves each punch to the nearest 5, 6, or 15 minutes before any sums. With 15-minute rounding, a clock-in at 08:07 becomes 08:00 and one at 08:08 becomes 08:15. Pay is gross: regular hours times the rate, plus overtime hours times the rate times the multiplier. Taxes and deductions are not in that figure. The page's own example at $20 an hour: Monday to Friday, 09:00 to 17:30 with a 30-minute break, is 8 hours a day, 40 hours in total, no overtime, and $800.00 gross. Monday to Friday, 08:00 to 18:00 with a 30-minute break, is 9.5 hours a day, 47.5 hours in total, of which 40 are regular and 7.5 are overtime, and $800 plus $225 is $1,025.00 at 1.5 times. Download CSV writes one row per day and a totals row at the end. The overtime result is an estimate, not payroll or legal advice.

How to calculate hours on a timesheet

  1. Take the span you are unsure about, including an overnight or a range of several days, and enter the start and end in the Time Duration Calculator. Read the decimal hours. A colon time such as 8:25 is not 8.25 hours.
  2. If every working day uses that same start, end, and unpaid break, enter them in the Work Hours Calculator with the days per week. Take vacation and public holidays off the yearly total yourself. That total does not remove them.
  3. If the days differ, open the Time Card Calculator. Enter each clock-in, clock-out, and unpaid break. Use Add shift for a split shift and leave days off empty.
  4. Set the weekly overtime threshold and the multiplier to the figures on your pay rules. The defaults are 40 hours and 1.5. Turn on a daily threshold only when those rules have one, and match rounding to the 5, 6, or 15 minutes your employer uses.
  5. Read the pay line as gross. Tax and other deductions are not included, and the overtime total is an estimate. Download the CSV if you want the week in a spreadsheet.

What these three calculators leave out

  • The same start and end without dates is 0 hours, not a 24-hour shift. Daylight-saving changes are not applied, because the times have no time zone.
  • The yearly figure from a repeating schedule does not subtract vacation or public holidays, and every working day is assumed to match.
  • A break as long as the shift, or longer, is an error. On the time card, a break longer than that day's shifts is an error for that day. An empty day is 0 hours.
  • Overtime rules vary by country and employer. The time card result is an estimate, not payroll or legal advice. Pay is gross. Taxes and deductions are not included.

Frequently asked questions

Why is 8 hours 25 minutes not 8.25 hours?

8.25 hours is 8 hours and 15 minutes. Twenty-five minutes is 25 divided by 60, which is 0.4167, so the decimal is 8.4167. Writing 8.25 shorts that line by 10 minutes.

How do I count a shift that ends the next morning?

If the end time is earlier than the start, add 24 hours. The duration calculator marks that span Overnight. With dates filled in, an end before the start is an error until you swap the two points.

What if my hours are different every day?

The work hours calculator assumes each working day has the same hours. Use the time card for different clock times, split shifts, and a weekly total with overtime.

Does the pay amount include tax?

No. The time card pay line is gross pay from the hourly rate and the overtime multiplier. Taxes and deductions are not included, and the overtime total is an estimate.

Often used together with the Add up hours on a timesheet.

More from the blog

All guides