Calculators

Timesheet Hours Calculator

Calculate elapsed work hours from a start time, end time, and unpaid break. Enter times as decimal hours on a 24-hour clock. For an overnight shift, enter the end time on the following day by adding 24 hours.

Loading calculator...

What this Timesheet Hours Calculator does

The Timesheet Hours Calculator estimates the hours worked in one shift. Enter a start time, an end time, and the duration of any unpaid break. The result subtracts the break from the elapsed time between the two entries. It is useful for checking a daily timesheet, planning a project work log, or reviewing how much time a task took before recording it in a tracker.

Times are entered as decimal hours on a 24-hour clock, rather than as clock notation. For example, 9:30 a.m. is 9.50, and 5:15 p.m. is 17.25. A shift that crosses midnight needs an end-time value on the following day. Add 24 to the clock time: a 1:00 a.m. finish is entered as 25.00. This convention lets the same subtraction work for daytime and overnight shifts.

The result is an elapsed-hours calculation. It does not determine pay, overtime, leave, billable status, or compliance with workplace rules. Those may depend on policies and information beyond the three entries here.

How to use the Timesheet Hours Calculator

Use one calculation for each continuous shift. Convert both clock times to decimal hours, enter the break duration in hours, and read the Hours Worked result. Keep the entries in the same unit and use a consistent time convention.

  • Start time: Enter the shift’s starting clock time as a decimal hour, from 0 to 23.99.
  • End time: Enter the finishing time. For a shift continuing into the next day, add 24 to the next day’s clock time.
  • Unpaid break: Enter the total unpaid break duration in hours. Use zero if there was no unpaid break.

For example, a shift beginning at 9:00 a.m. and ending at 5:00 p.m. uses 9.00 and 17.00. If the worker took a 30-minute unpaid break, enter 0.50. The calculator returns 7.50 hours worked. If a shift includes several breaks, add their unpaid durations together before entering the total.

To convert minutes into decimal hours, divide the minutes by 60. Thus 15 minutes is 0.25 hours, 30 minutes is 0.50 hours, and 45 minutes is 0.75 hours. Entering 30 as the break would mean 30 hours, so this conversion is important.

How the Timesheet Hours Calculator formula works

The formula is end_time - start_time - unpaid_break. It first finds elapsed time by subtracting the start from the end, then removes the unpaid break. All three values represent hours, so the resulting Hours Worked value is also in hours.

Consider a project coordinator who starts at 8:45 a.m., finishes at 4:30 p.m., and takes a 45-minute unpaid break. Convert the times to 8.75 and 16.50, and the break to 0.75. The calculation is 16.50 - 8.75 - 0.75 = 7.00 hours. The units remain consistent throughout the calculation.

For an overnight example, a support shift runs from 10:30 p.m. to 2:15 a.m. the next day, with a 15-minute unpaid break. Enter 22.50 for the start, 26.25 for the end (2.25 + 24), and 0.25 for the break. The calculation is 26.25 - 22.50 - 0.25 = 3.50 hours.

A result below zero usually signals that the end time or break was entered incorrectly, or that the next-day convention was not applied. A break equal to the full elapsed shift leaves zero hours. Check the entries and the applicable timekeeping policy before using a result in a record.

Use cases for the Timesheet Hours Calculator

A simple shift total can help people keep project records consistent. For example, a community organization coordinating an event may record planning, setup, and follow-up work separately. Calculating each shift’s net hours makes it easier to transfer the same figures into a project log or weekly summary.

Independent contractors and small project teams can also use a timesheet to review how time is distributed across tasks. A daily total is a building block. When combining shifts, calculate each separately and add the resulting hours, taking care not to count the same time twice.

The calculator is suited to a single uninterrupted time span with a break total. If a person clocks out and back in for separate work periods, calculate those spans separately. This makes gaps and breaks easier to inspect and avoids treating non-work time as work time.

For reliable records, keep the original clock entries alongside the calculated total. A brief note about the task or project can make later review easier, particularly when several people contribute to different workstreams.

Other factors to consider when calculating hours

A calculator can perform the subtraction, while the timesheet still depends on clear recording practices. Confirm whether breaks are paid or unpaid under the applicable policy, and record only the duration that should be excluded from worked hours. Rules for rounding, overtime, travel, and split shifts vary by workplace and jurisdiction. This tool does not interpret them.

Decimal time can also differ from hour-and-minute notation. For example, 7.5 hours means seven hours and 30 minutes, while 7.30 decimal hours means seven hours and 18 minutes. Convert minutes by dividing by 60 instead of placing them after a decimal point.

Finally, use the same local time convention for both entries. If a shift crosses midnight, add 24 to the following day’s end time as described above. This basic approach does not account for daylight-saving clock changes or other unusual timekeeping events, so verify those records with the system or policy used by the organization.

Frequently asked questions

How do I enter 9:30 a.m. as a decimal time?

Convert 30 minutes to hours by dividing by 60. The result is 0.50, so enter 9.50 for 9:30 a.m.

How should I enter an overnight shift?

Add 24 to the next-day end time. For a 1:00 a.m. finish, enter 25.00. Subtract the start and any unpaid break as usual.

Should I include a paid break?

This calculator subtracts the break amount entered. Enter only the duration that should be excluded under the relevant timesheet policy. If a break is counted as paid work time, do not include it in the unpaid-break value.

Can I calculate a week of work at once?

This configuration calculates one shift at a time. Calculate each shift, then add the Hours Worked results for a weekly total. Keep the daily entries so you can check the sum.

Does Hours Worked tell me what I should be paid?

No. It reports elapsed hours after the entered unpaid break. Pay may depend on rates, overtime rules, paid breaks, deductions, and other factors that are outside this calculation.

Written by

ethicsandentrepreneurship.org Editorial Team

Editorial team

ethicsandentrepreneurship.org publishes practical how-to guides and educational articles with clear steps and useful context.