How to calculate hours worked accurately

Key takeaways

Start with the purpose of the total. Employee working time, GB working-time limits and contractor project or billable time follow different rules. Identify the worker relationship, jurisdiction, reporting period and governing agreement before counting intervals.
For each shift, subtract the complete start timestamp from the complete end timestamp, subtract only breaks that qualify for exclusion, and divide the remaining minutes by 60 to obtain decimal hours.
Record dates and time-zone offsets when a shift crosses midnight or a daylight-saving transition. Local clock time alone may identify the wrong instant during a clock change.
Sum eligible minutes within a named workweek, month or project. Days off add zero, while overlapping or duplicate entries must be reconciled before aggregation.
Keep ordinary hours, overtime and other categories separate. A monthly total does not determine US federal overtime, which generally depends on hours worked in a fixed recurring workweek for covered nonexempt employees.
Treat rounding as a separate decision. Showing a final total to two decimal places does not change the stored duration; time-clock rounding changes the value used in the calculation and requires review under the applicable rule or agreement.
Preserve the original entries, break information, corrections and approval reasons. A calculator can perform arithmetic, but a reviewer must decide whether the underlying activity and breaks belong in the total.

Decide what the total must count

First decide what the total measures. US employee hours, GB working-time limits and contractor project time serve different purposes and can classify the same activity differently.

Identify four things before entering any hours into a calculator:

The worker relationship: employee, contractor or another arrangement.
The jurisdiction and the purpose of the record.
The rule or agreement that governs the classification.
The actual activity and break facts for each interval.

Choose the purpose and worker status: US employee hours, GB working-time limits or contractor project time. Apply the relevant rules or agreement to activities and actual breaks. — Classify actual activities and breaks under the rule or agreement relevant to the total. US employee hours, GB working-time limits and contractor project totals have different purposes. 29 CFR 785.19: Meal periods · Acas: Working time rules · GOV.UK: Calculating your working hours

Employee working time and contractor project time

For US covered employees, the federal definition of hours worked includes certain work that occurs outside the scheduled shift when the employer knows or has reason to believe that the work continues. A scheduled roster therefore describes expected work; it does not necessarily determine the total.

In Great Britain, Acas guidance on the Working Time Regulations uses a different purpose. It includes work duties, job-related training, some travel and certain on-call periods. Routine commuting to a fixed workplace and breaks during which no work is done generally fall outside that working-time definition. These rules serve the GB working-time regime and should not be treated as a universal wage calculation.

Contractor project or billable time requires the applicable agreement and law. The agreement should state what the parties mean by project time, billable time and extra hours, as well as how breaks, approval, reporting periods and corrections are handled. Employee working-time rules do not supply a universal definition of billable work for a contractor.

Keep separate totals when the purpose differs. An employee-hours record used for a statutory working-time check should not automatically become a contractor invoice, and a project total should not be relabelled as employee working time.

Work outside the scheduled shift

A shift record can undercount the relevant total when work continues beyond the roster. For US covered employees, work that is suffered or permitted counts as working time when the employer knows or has reason to believe it is occurring, even if the employer did not request it.

Review records for:

Work performed after the scheduled end time.
Work performed before the scheduled start time that the employer knew or had reason to believe was occurring.
Work sent or approved outside the recorded shift.
Unrecorded work identified during a later review.

Do not deduct these intervals automatically from an employee’s total. First establish the applicable rule and the facts. A contractor’s extra work may fall within the agreement, may require approval or may belong to a separate task. The arithmetic cannot decide that classification.

Travel, training and on-call time

Classify travel, training and on-call intervals under the worker’s governing rule or agreement. The same activity may count for one purpose and not another.

Under US federal hours-worked rules:

Ordinary travel from home to work is not working time.
Travel between job sites during the workday, when it is part of the employee’s principal activity, counts as hours worked.
Training can be excluded from working time only when all four statutory conditions are met: it occurs outside regular working hours, is voluntary, is not directly related to the job and involves no productive work.
On-call time counts when the person must remain on the employer’s premises or so close to it that effective personal use is restricted. Merely leaving contact details while off the premises does not meet that test.

GB working-time guidance may include work-related training, some job travel and workplace on-call time. For contractor project time, check whether the agreement treats travel, training and waiting as billable or non-billable.

Record what the person did and where they had to be. A label such as “travel” or “training” does not establish whether the interval counts.

Breaks actually taken

A break deduction should reflect the break that occurred and its treatment under the applicable rule. The same 30-minute clock interval can produce a different result depending on what happened during it.

For US covered employees:

Short rest periods of about five to 20 minutes count as hours worked.
A bona fide meal period falls outside working time when the employee is completely relieved of duty.
Performing duties during the meal means the employee was not fully relieved from duty, so the interval cannot be treated as a duty-free meal on those facts.
Work performed during an interrupted break must be examined before a fixed deduction is accepted.

Record the actual start and end of the break when it differs from the scheduled deduction. If an employee missed the break, continued working during it or interrupted it, preserve the original entry and document the correction. GB working-time guidance treats a break with no work performed differently from active work, while contractor break treatment depends on the agreement and applicable law.

Use the actual break record when calculating the shift; a scheduled deduction alone does not establish that the break occurred or qualified for exclusion.

Record complete start and end times

Record the date and clock time at both ends of a shift. Where a clock change or time-zone difference could affect the interval, record the zone or UTC offset needed to identify each endpoint.

Record the start date and time, then the end date and time. Resolve the time zone or offsets at both endpoints where a clock change may occur, then subtract the unambiguous timestamps to find elapsed time. — Use complete dates and times. Where a clock change may occur, resolve each endpoint with its time zone or offset before calculating elapsed time; a local clock time can be ambiguous. IETF RFC 9557: Date and time on the internet · Microsoft: Calculate the difference between two dates

Overnight shifts and multiple dates

For an overnight shift, include the date on each side of the interval. A shift beginning at 22:00 on day 1 and ending at 06:00 on day 2 has an elapsed duration of eight hours before any qualifying break is deducted.

Do not calculate the interval by subtracting the clock faces in isolation. The subtraction works from complete timestamps:

elapsed minutes = end date and time − start date and time

For the example above:

120 minutes to midnight + 360 minutes after midnight = 480 minutes

Keep the break deduction separate from this elapsed time. If a 30-minute break qualifies for exclusion, the worked duration becomes 450 minutes, or 7 hours 30 minutes.

A worker may also have several shifts across one or more dates. Give each shift its own start and end, then classify and calculate each eligible interval before adding them to the relevant period. This prevents a missing date or an overlapping entry from disappearing inside a larger total.

Time zones and daylight saving changes

A UTC offset records the difference from UTC at one timestamp. A named time zone supplies the rules that determine the offset on a particular date. For ordinary intervals, an offset may be sufficient; around a daylight-saving transition, the offset at the start and end may differ.

Local clock time can also be ambiguous during a transition. IETF RFC 9557 explains that some local times can map to zero or multiple actual instants because of nearby clock changes. A time-entry form that stores only “02:30” cannot distinguish those possibilities.

Use dated, offset-aware inputs when a shift may cross a transition. The same clock interval can have different elapsed durations:

Example	Start	End	Elapsed time
Spring-forward transition	22:00 at −05:00	06:00 at −04:00	7 hours
Fall-back transition	22:00 at −04:00	06:00 at −05:00	9 hours

These are illustrative offset pairs, not a statement about a particular date or place. Each endpoint must be resolved to its actual instant before subtraction.

If a record contains only local dates and clock times, check whether the interval crosses midnight, whether either endpoint belongs to a daylight-saving transition and whether the relevant zone observes that change. Where the instant remains ambiguous, preserve the original entry and obtain the missing zone or offset information before calculating the duration.

Calculate hours for one shift

Calculate one shift in three steps: subtract the complete start timestamp from the complete end timestamp, subtract only breaks that the applicable rule or agreement excludes, then convert the remaining minutes to hours. This produces a duration; it does not determine whether an interval legally counts as work.

Subtract timestamps and qualifying breaks

Start with elapsed time:

elapsed minutes = end timestamp − start timestamp

Then deduct qualifying breaks:

worked minutes = elapsed minutes − qualifying break minutes

A break qualifies for deduction only within the applicable scope. For example, under US federal rules for covered employees, a short rest period of about five to 20 minutes counts as working time, while a bona fide meal period falls outside working time when the employee is completely relieved of duty. If the person performs duties during the meal, the facts do not support treating it as a duty-free meal.

Contractor break treatment depends on the agreement and applicable law. GB working-time guidance also distinguishes breaks with no work from active work. Record what actually happened rather than deducting the scheduled break automatically.

Keep the calculation in minutes until the classification is complete. Converting early can hide an unnecessary break deduction or make a later check harder to perform.

Convert hours and minutes to decimal hours

Keep the whole minutes and divide by 60:

decimal hours = worked minutes ÷ 60

For example, 450 minutes becomes:

450 ÷ 60 = 7.5 decimal hours

For a shift containing a whole number of hours plus minutes, calculate the minutes first:

decimal hours = whole hours + remaining minutes ÷ 60

A duration of 7 hours 30 minutes is therefore 7.5 decimal hours. Retain the underlying duration rather than copying only the rounded display into a spreadsheet. Displaying 7.50 does not change the underlying 450-minute value.

Worked shift examples

The following examples assume that each stated break qualifies for deduction. If the person worked through a break, was not fully relieved from duty or a contractual term treats the interval differently, recalculate the result.

Day shift with a break

A shift runs from 09:00 to 17:00:

Elapsed time:
(17 × 60) − (9 × 60) = 480 minutes

Less a qualifying 30-minute break:
480 − 30 = 450 minutes

As hours and minutes:
450 minutes = 7 hours 30 minutes

As decimal hours:
450 ÷ 60 = 7.5 hours

The scheduled span is eight hours. The worked duration is 7.5 hours because the qualifying break removes 30 minutes.

Overnight shift

A shift runs from 22:00 on day 1 to 06:00 on day 2:

Elapsed time:
120 minutes to midnight + 360 minutes after midnight = 480 minutes

Less a qualifying 30-minute break:
480 − 30 = 450 minutes

As hours and minutes:
450 minutes = 7 hours 30 minutes

As decimal hours:
450 ÷ 60 = 7.5 hours

Both dates are part of the calculation. This example assumes a fixed offset. If the shift crosses a daylight-saving transition, resolve both endpoints with their applicable offsets before subtracting them.

Add hours for a week, month or project

Add eligible durations in minutes, then convert the final total. Choose the period boundary before summing: a calendar month, a project, a pay period and a legally defined workweek can contain different entries and answer different questions.

Multiple shifts and days off

Calculate each shift separately before adding it to the period:

period minutes = sum of eligible worked minutes for each entry

A day off adds zero worked minutes. Multiple shifts on the same date remain separate entries until you have checked that they do not overlap.

Reconcile duplicate or overlapping records before aggregation. If two entries cover the same interval, adding both double-counts the work. If one entry was created to correct another, preserve the original and include the corrected version once.

Keep the calculation in exact minutes until the period total is complete. For example:

Monday: 450 minutes
Tuesday: 480 minutes
Wednesday: 420 minutes
Thursday: 450 minutes
Friday: 360 minutes

Period total = 450 + 480 + 420 + 450 + 360 = 2,160 minutes
2,160 ÷ 60 = 36 decimal hours

These figures illustrate the aggregation method rather than a standard work schedule.

The right period boundary

Name the boundary before adding entries. For a month, decide whether the period runs from the first through the last calendar day or follows the company’s defined reporting cycle. For a project, use the approved project period. For US federal overtime, use the employer’s fixed recurring workweek.

A US workweek is a fixed, recurring seven-day period of 168 hours. It may begin on any day or hour and does not have to match Monday-to-Sunday or the calendar month. A monthly total cannot answer a question about overtime in an individual US workweek unless the underlying weekly records are also available.

A 2019 study comparing UK survey responses with seven-day time-schedule entries found group-level differences between remembered usual or actual hours and recorded schedules. People reporting long hours tended to overestimate relative to the schedules, while people reporting short hours tended to underestimate; more variable schedules also showed larger gaps. The study used UK Time Use Survey data from 2000 and 2015, so its findings do not establish payroll error rates or transfer directly to an individual record. Its practical implication is limited but useful: preserve dated entries and sum the records instead of reconstructing a typical week from memory.

Separate project and billable totals

Keep a total that combines unrelated work separate from totals that answer project or billing questions. Use separate fields or ledgers for:

Each project or client.
Billable and non-billable work.
Time worked under different contracts.
Work performed outside the approved scope.

Do not label a combined total as billable merely because some entries are billable. A billable total should include only time that satisfies the agreement’s definition and the applicable approval process.

For contractor project hours, use the agreement and applicable law to define billable work. Check how the agreement treats breaks, travel, waiting, expenses, approval deadlines, extra hours and rounding. A timesheet total can be arithmetically correct and still fail the contractual test for a billable amount.

Average weekly working time where required

Some questions require an average across a reference period rather than the sum for one week. In Great Britain, the maximum weekly working-hours calculation normally averages over 17 weeks. A week above 48 hours does not by itself establish a breach when the average over the reference period remains below the limit, subject to the applicable exceptions and agreements.

Use the correct numerator and period:

average weekly hours = total hours in the reference period ÷ number of weeks in the reference period

For example, a 17-week reference period containing 765 hours gives an average of 45 hours per week:

765 ÷ 17 = 45 hours per week

This is a GB working-time calculation, not a US overtime calculation, a wage-rate calculation or a universal contractor-billing formula. Keep each total attached to its stated purpose and period boundary.

Calculate hours in Excel or Google Sheets

A spreadsheet can calculate durations, deduct breaks and sum totals beyond 24 hours. The important setup choice is how you store each input: a complete date and time should remain a date-time value, not a text label such as “Tuesday, 9 a.m.”

Store dates and times as values

Enter the start and end as complete date-time values. For an overnight shift, both dates must be present:

Entry	Start	End	Qualifying break
Day 1	07.11.2026 09:00	07.11.2026 17:00	00:30
Overnight	07.11.2026 22:00	08.11.2026 06:00	00:30

The examples use a fixed offset assumption. Where a clock change may occur, retain the time-zone information separately or in an unambiguous timestamp representation. A local time without a date or offset can leave the intended instant uncertain.

Excel and Google Sheets support date and time formatting. Google Sheets derives its default date and time formats from the spreadsheet locale, so a value that displays differently may still be stored correctly. Verify each typed entry rather than relying on its appearance alone.

Use these fields for a reviewable row:

Person or contractor identifier.
Start date and time.
End date and time.
Time zone or offset when relevant.
Break duration.
Project or work category.
Source entry, adjustment and approval fields.

A separate date column is useful for grouping and reconciliation, but it does not replace the full dates used in the duration calculation.

Calculate duration and deduct breaks

With start and end in cells B2 and C2 and the qualifying break in D2, calculate the elapsed duration with:

=C2-B2

Deduct the qualifying break with:

=(C2-B2)-D2

Format the result as elapsed time or convert it to decimal hours:

=((C2-B2)-D2)*24

For a 09:00–17:00 shift with a qualifying 30-minute break:

Elapsed time: 8:00
Break: 0:30
Worked duration: 7:30
Decimal hours: 7.5

For a shift from 22:00 on 7 November to 06:00 on 8 November:

Elapsed time: 8:00
Break: 0:30
Worked duration: 7:30
Decimal hours: 7.5

The break formula assumes the entry qualifies for deduction. Link that deduction to the classification decision rather than calculating it from the scheduled shift alone. If the source record contains an interrupted or missed break, do not replace the actual information with the scheduled value.

Sum totals beyond 24 hours

A normal clock format wraps at 24 hours, so it cannot represent a weekly total of 36 hours cleanly. In Excel, apply the custom format [h]:mm to a duration or total cell. The brackets tell the spreadsheet to continue displaying accumulated hours.

For eligible durations in cells E2 through E6, use:

=SUM(E2:E6)

Google Sheets uses the same SUM function to add numeric cells or ranges. Apply an equivalent elapsed-time display that continues beyond 24 hours, then use a separate decimal-hours formula when a decimal total is required.

Check three values independently:

The sum of exact minutes.
The hours-and-minutes display.
The decimal-hours display.

For 2,160 minutes, the three representations are 36 hours, 36:00 and 36.0. They describe the same duration in different formats.

Check a spreadsheet against source entries

Reconcile the spreadsheet with the original records before using its total. Select several entries across the period, including any overnight shift, break or corrected row, and confirm that the cell formula reproduces the source arithmetic.

Check for:

Missing or duplicated dates.
End times earlier than start times without a later date.
Overlapping entries.
Break deductions that do not match the recorded break.
Values imported as text rather than date-time values.
Daylight-saving shifts whose local times were not converted to unambiguous instants.
Totals that include a different period, project or worker than the label states.

Use a source reference or unique entry identifier for each row. When a reviewer corrects a value, retain the original entry and the reason for the adjustment rather than overwriting the only copy.

If reviewers cannot trace an included interval, break deduction or correction to its source, an accurate formula cannot make the total reviewable.

Separate ordinary hours from overtime

A worked-hours total becomes ordinary time, overtime or another category only after you identify the worker’s status, jurisdiction and governing rule or agreement. The arithmetic total remains the same; the classification depends on the period and category rules that apply to that person.

US workweek threshold for covered employees

For covered nonexempt employees under US federal rules, overtime generally applies to hours worked above 40 in a fixed, recurring workweek of 168 hours. The workweek may begin on any day or hour; it does not have to match the calendar week.

Hours cannot be averaged across two or more weeks to determine whether the 40-hour threshold was exceeded. For example, an employee who works 50 hours in one workweek and 30 in the next still has 50 hours in the first workweek for the federal threshold calculation.

Before classifying an hour as overtime, check:

Whether the worker is covered by the federal rule and nonexempt from overtime.
Whether any state or local rule adds a daily threshold or changes other requirements.
The employer’s fixed workweek boundary.
Whether the hours are working time under the applicable rule.
The regular rate and any other required calculation.

A monthly total cannot identify US federal overtime without the hours assigned to each workweek. State requirements may add obligations beyond the federal baseline, so the 40-hour threshold should not be treated as a complete US rule for every employer.

UK working-time limits and other local rules

Great Britain’s Working Time Regulations and overtime-pay rules answer different questions. A working-time total may support compliance with limits such as the average weekly maximum, while the calculation of pay for additional hours may depend on other employment terms and rules.

For the GB maximum weekly working-hours calculation, the average is normally taken over a 17-week reference period. Subject to the applicable exceptions and agreements, an employer may work someone above 48 hours in one week while keeping the average across the reference period below 48 hours per week.

That does not turn the GB working-time average into a US-style overtime calculation. Keep separate records for:

Working time used for the GB limit and its reference period.
Hours subject to an overtime or premium-pay term.
Hours recorded for contractual or project purposes.

Other jurisdictions have their own thresholds, daily limits, reference periods and record requirements. Do not transfer the US 40-hour rule to Great Britain, Germany, Cyprus or another jurisdiction, and do not present the GB 48-hour working-time limit as a universal overtime threshold.

Contractor extra-hour terms

For a contractor, extra hours arise from the applicable agreement and law. Before classifying a period as billable extra time, check:

The agreed rate and whether it changes after a threshold.
Whether the threshold applies per day, week, month, project or another period.
Which activities qualify as billable work.
Whether travel, waiting, training or breaks are included.
The required approval process and reporting deadline.
Whether time must be recorded contemporaneously or submitted through an agreed process.

A contractor may agree that work beyond a project budget needs approval before it becomes billable. Another agreement may treat approved hours above a weekly threshold as subject to a premium rate. Neither outcome can be inferred from the hour count alone.

Keep the underlying calculation visible. Preserve the classified hours, the period used for the contractual threshold, the approval and the resulting billing category. If the agreement does not define extra-hour treatment, obtain that definition before labeling hours as premium or billable.

Label the result under the applicable rule or agreement; the hour count alone cannot establish the category.

Round and correct time without losing the source record

Rounding and correcting a time record are two different operations. Rounding changes the value used in a calculation; a correction changes the record to reflect what actually happened. Keep the original entry, the adjustment and the reason for it so another reviewer can follow the result.

Decimal display versus time-clock rounding

Changing the display of a calculated duration does not change its stored value. A spreadsheet can store 450 minutes and show the result as 7.50, 7:30 or 450 minutes. These are different presentations of the same underlying duration.

Time-clock rounding is different. It changes the start or end record to a permitted increment before calculating the period total. Under US federal rules for covered employees, rounding to five minutes, one-tenth of an hour or a quarter hour is acceptable only when the practice does not, over time, fail to compensate employees properly for all time actually worked. Other jurisdictions and agreements may impose different requirements.

A rounding decision therefore needs a documented basis:

The applicable jurisdiction, worker status and rule or agreement.
The exact clock-in and clock-out records.
The rounding method and where it is applied.
The cumulative difference between exact and rounded time.
Any rule-specific limits or exceptions.

Do not treat “round to the nearest quarter hour” as a universal rule. It is neither a general display format nor automatically a permissible time-clock method.

Compare rounded and exact totals

Run the same entries through both calculations and compare the results. Keep exact minutes as the baseline. For this US federal time-clock illustration, round each start and end punch separately to the nearest quarter hour, then subtract the rounded timestamps. In all four rows, the punches become 09:00 and 17:00.

Entry	Exact duration	Duration from rounded punches	Difference
08:57–17:04	8 hours 7 minutes	8 hours	−7 minutes
09:02–17:01	7 hours 59 minutes	8 hours	+1 minute
08:58–17:03	8 hours 5 minutes	8 hours	−5 minutes
09:01–16:59	7 hours 58 minutes	8 hours	+2 minutes

The illustrative four-entry period totals 32 hours 9 minutes exactly and 32 hours after rounding. The rounded total is nine minutes lower than the exact total for this set of entries.

Payroll, working-time and contractual calculations may use different rounding rules. Compare the exact and rounded record under the rule that governs the actual purpose of the total. A rounded display used for a report should not replace a time-clock rule used for compensation.

Resolve missed breaks and overlapping entries

A scheduled break is an input to review, not proof that the break occurred. Check the original entries and activity before applying a deduction.

When a recorded break was interrupted, review the actual start and end of the interruption before changing the total. Keep the original entry and the reason for the correction together, so another person can follow the decision.
— Mike Smirnov

For a missed or interrupted break, establish:

The break’s scheduled start and end.
When the person actually stopped working.
When the person resumed working.
Whether the interruption was short enough to fall within the governing break rule.
Which minutes the corrected entry includes or excludes.

For overlapping entries, identify which record covers the shared interval and whether the other entry should be shortened, removed from the total or retained for a different purpose. Never add both overlapping intervals to the eligible total.

Preserve enough information to reconstruct the decision:

Original start, end and break values.
The corrected values.
The reason for the change.
The person who reviewed or approved the correction.
The date of the review.

US federal recordkeeping rules for covered employees require hours worked each workday and the total for each workweek. When a fixed schedule is used, actual departures from that schedule must be recorded. GB working-time record requirements serve a different purpose and do not require every employer to keep all daily hours under those regulations. The review process should therefore be tailored to the governing obligation while preserving a clear audit trail.

Choose a record method people can review

Choose a record method that preserves the source entry, supports the period and category decisions, and gives a reviewer enough context to explain the final total. A manual timecard or spreadsheet may suffice for a small set of entries. A shared workflow can help when several people submit corrections or review project time.

Manual timecards and spreadsheets

A manual timecard can hold a small number of shifts that a reviewer can check against source records. A spreadsheet adds useful calculation and grouping features, but the quality of the total still depends on its inputs.

For each entry, capture:

The person and work category.
Complete start and end dates and times.
The time zone or offset when relevant.
The actual break and its classification.
The project or billable category.
Any correction and approval reference.

Keep dates and times as date-time values, use exact minutes for calculations and store the period boundary explicitly. A formula cannot determine whether an employee remained on duty during a meal, whether permitted work continued after the roster, or which contractor time the agreement treats as billable.

Before finalizing a spreadsheet, reconcile it with the original entries. Check overnight shifts, daylight-saving intervals, overlapping records and rows with corrections. If a reviewer cannot tell why a value changed, the spreadsheet may still calculate accurately while remaining difficult to defend.

Shared records and correction history

When several people contribute entries, corrections or approvals, a shared record should show the original values and who changed them, why and when.

A reviewable correction normally includes:

The original start, end and break values.
The revised values.
The reason for the adjustment.
The reviewer and approval date.
The affected period, project or category.

Do not overwrite the only copy of a disputed entry. This preserves the source record and gives the reviewer a trace from the final total back to the underlying activity. It also makes anomalies visible: missing ends, duplicate intervals, automatic deductions and corrections that change a threshold category.

The record format must match the legal and operational purpose. US federal recordkeeping rules for covered employees require daily and workweek hours, including actual deviations from a fixed schedule. Acas guidance says GB employers need records that prove compliance with specified working-time limits, but they do not have to retain all daily hours for that purpose. A contractor project record should follow the agreement’s approval and reporting terms.

When a calculator is insufficient

A calculator performs arithmetic after its inputs and decisions are established. It cannot determine the governing rule, classify an interrupted break, identify permitted off-schedule work, resolve an ambiguous timestamp or decide whether two overlapping entries belong in the same total.

Move the review to a person when:

The worker relationship or governing agreement is unclear.
The activity or break is disputed.
An overnight timestamp lacks a date, time zone or offset.
Two entries overlap.
A correction changes overtime, billable status or another category.
The exact and rounded totals differ beyond the applicable tolerance.
The period boundary is missing or mixed with another period.

Record which intervals count, which are excluded, which period received them and who approved the result. That trail lets another reviewer reproduce the total without relying on memory or an unexplained correction.

Frequently asked questions

How many hours is a 9 to 5 shift?

A 09:00–17:00 shift contains eight elapsed hours. If a qualifying 30-minute break is excluded, the worked duration is 7 hours 30 minutes, or 7.5 decimal hours. If no break qualifies for exclusion, the total remains eight hours.

How many hours is 8 to 5 with a lunch break?

An 08:00–17:00 shift contains nine elapsed hours. With a qualifying 30-minute lunch break, the worked duration is 8 hours 30 minutes:

(17 × 60) − (8 × 60) − 30 = 510 minutes
510 ÷ 60 = 8.5 decimal hours

The 30-minute deduction applies only when the break qualifies for exclusion under the applicable rule or agreement.

How do I calculate total hours worked for a month?

Calculate each eligible shift in minutes, then add the results within the defined month or reporting period. A day off contributes zero. Exclude or reconcile duplicate and overlapping entries before summing, and divide the final minutes by 60 to obtain decimal hours.

A monthly total alone does not determine US federal overtime, which generally depends on hours worked in each fixed recurring workweek.

Should I round to the nearest quarter hour?

Only when the applicable rule or agreement permits that time-clock method. Changing a final display to two decimal places does not change the underlying duration. Time-clock rounding changes the value used in the calculation, so compare exact and rounded totals across the period.

Under US federal rules for covered employees, permitted rounding cannot, over time, fail to compensate the worker properly for all time actually worked.

How do I calculate hours worked for an overnight shift?

Record both dates and subtract the complete start timestamp from the complete end timestamp. For example, 22:00 on day 1 to 06:00 on day 2 is eight elapsed hours. Subtract only a qualifying break, then divide the remaining minutes by 60.

If the interval crosses a daylight-saving transition, resolve each endpoint with the relevant time zone or UTC offset. Local clock time alone may not identify the correct elapsed duration.

Can I multiply decimal hours by an hourly rate?

Yes, for a simple rate-based estimate:

estimated amount = eligible decimal hours × hourly rate

For example, 7.5 hours at $40 per hour gives $300. This arithmetic does not determine whether every hour is eligible for the ordinary rate. Overtime may require a separate regular-rate calculation and premium, while contractor billing may follow the agreement’s rates, approval rules and extra-hour terms.

Conclusion

An accurate hours-worked total depends on the purpose, worker relationship, governing rule or agreement, complete timestamps and period boundary. Once those decisions are made, the arithmetic is direct: subtract qualifying breaks from the elapsed minutes, divide by 60 and sum eligible intervals within the stated period.

Keep the record reviewable. Preserve the original entry, classify actual breaks and activities, document corrections and compare exact and rounded totals. A precise calculation still depends on the correct interval, period and category.