Get Work Hours Between Dates: Formula and Calculator

Use this calculator to get the elapsed work hours between two date-and-time entries: enter the start and finish times and the hours you want to count as nonworking, and it returns the net duration in hours. It is useful for a simple shift or continuous time span; it does not automatically account for weekdays, holidays, breaks on particular dates, or changing schedules.

Formula

Work hours = finish time − start time − unpaid break. In the calculator, start and finish are the time-of-day values expressed as decimal hours after midnight, and break is the break duration in hours. The first result is the net number of hours. The second shows that duration as hours, minutes, and seconds.

This calculation treats the entries as points on the same day. For example, 9 means 9:00 a.m. and 17 means 5:00 p.m. A shift crossing midnight needs the finish time adjusted to the next day, which this basic same-day formula cannot infer from time-of-day values alone. For multiple dates, calculate each work period separately or use actual date-and-time timestamps and sum the net durations.

Worked Example

Using the default values, start = 9 hours, finish = 17 hours, and unpaid break = 0 hours:

• Elapsed time = 17 − 9 = 8 hours.
• Net work time = 8 − 0 = 8 hours.
• In minutes, 8 × 60 = 480 minutes, or 8:00:00.

The calculator therefore returns 8.00 hours and a duration of 8:00:00.

Getting Work Hours Across Dates

For a period that spans several calendar dates, work hours generally mean the sum of the time actually worked during the applicable shifts—not every hour between the first start and final finish. Identify each shift, subtract unpaid breaks, and add the net durations. For a regular Monday-to-Friday schedule, count the scheduled workdays in the range and multiply by daily hours only if each day follows that schedule and no exceptions need to be included.

For example, suppose a person works 8 hours each weekday from Monday through the following Sunday, with no holiday or leave. There are 10 weekdays in that Monday-to-Sunday range, so the scheduled total is 10 × 8 = 80 hours. If the period instead runs Wednesday through the following Tuesday, there are six weekdays, or 48 scheduled hours. These totals assume the first and last dates are included and that all weekdays are workdays.

For changing schedules, use a shift list rather than a weekly multiplier. A practical method is:

1. Write down each shift’s start and finish date and time.
2. Calculate the elapsed duration for each shift, including any midnight crossing.
3. Subtract unpaid breaks that fall within that shift.
4. Add the resulting durations, then convert minutes to decimal hours if needed.

Calendar Dates, Weekends, and Holidays

“Between dates” can mean different things. A date range may include both its start and end dates, exclude the end date, or refer to elapsed time from an exact starting instant to an exact ending instant. For a work-hours total, state the convention clearly. If someone asks for hours from Monday to Friday, they may mean five full workdays, or the interval from Monday morning to Friday evening; these are not necessarily the same.

Weekends and holidays do not have a universal treatment. Exclude them only when they are not scheduled workdays for the calculation in question. Some employees work weekends, and some workplaces operate on holidays. Similarly, a holiday occurring in a date range does not automatically reduce the total unless the schedule or the requested definition says to exclude it.

For exact elapsed time, use timestamps with a time zone when the period spans regions or a daylight-saving transition. A local clock can skip or repeat an hour when clocks change. The time between two clock readings may therefore differ from the actual elapsed time unless the date and time zone are known.

Decimal Hours and Time Formats

Payroll and time-tracking systems often display hours as decimal values, while people commonly describe time as hours and minutes. Convert minutes to a fraction of an hour by dividing by 60: 30 minutes is 0.5 hours, 15 minutes is 0.25 hours, and 45 minutes is 0.75 hours. Thus, 7 hours 30 minutes equals 7.5 hours—not 7.30 hours.

Round only at the point required by the system or task. Rounding each shift before adding can produce a different total from adding the exact minutes first and rounding once. Keep intermediate values in minutes or seconds where possible, especially when a period includes many short shifts.

Common Errors and Limits

• Counting the whole date range as work: Calendar days or elapsed hours do not automatically equal scheduled work hours.
• Forgetting unpaid breaks: Subtract only breaks that should be excluded under the definition being used; paid breaks may be treated differently.
• Mixing decimal hours and clock time: 8.25 decimal hours means 8 hours 15 minutes, not 8:25.
• Ignoring overnight shifts: A shift from 10 p.m. to 6 a.m. lasts 8 hours, not negative 16 hours. Use full dates or explicitly account for the next-day finish.
• Assuming a standard workweek: A weekday count is not reliable for rotating, part-time, compressed, or irregular schedules without checking the actual shifts.

This calculator is a straightforward duration tool, not a payroll, attendance, or scheduling system. It does not determine which breaks count, apply workplace rules, identify holidays, or calculate overtime. Those depend on the schedule and the relevant policies or requirements, so check the applicable source when the total is being used for an official record.

Frequently Asked Questions

How do I calculate work hours between two dates?
List the work shifts within the range, find each shift’s elapsed duration, subtract applicable unpaid breaks, and add the net durations. Count only scheduled working time, not every calendar hour.

How many work hours are in a date range?
It depends on the schedule and which dates are included. For a consistent five-day schedule, count the workdays in the range and multiply by daily hours, then adjust for absences, holidays, or exceptions that apply.

Do I include the start and end dates?
Use the convention specified for the task. For daily schedules, ranges are often counted inclusively, but an exact elapsed-time calculation uses a start timestamp and an end timestamp instead.

How do I calculate an overnight shift?
Use the actual start and finish dates. For a same-shift example, 10 p.m. to 6 a.m. the next day is 8 elapsed hours before subtracting any unpaid break.

Is 7.5 hours the same as 7 hours 30 minutes?
Yes. Multiply the decimal fraction by 60: 0.5 × 60 = 30 minutes. Decimal hours do not use the minutes-after-a-colon notation.

Should weekends and holidays be removed?
Only if they are not workdays for the schedule or definition you are using. A weekend or holiday can still be a scheduled shift.

Related

• ChatGPT Enterprise Data Retention, Training & Privacy
• Can’t Read From the Source File or Disk? Fixes
• Enable Full-Screen Incoming Calls on iOS 14

in start | Start time (hours) | h | 9 | 0
in finish | Finish time (hours) | h | 17 | 0
in break | Unpaid break | h | 0 | 0
out hours | Work hours | h | (finish - start) - break | 2
out duration | Net duration | time | ((finish - start) - break) * 60 | time