How do I calculate work hours with overtime?

In the United States, standard weekly overtime is calculated as any hours worked beyond 40 hours in a workweek. Overtime hours are typically paid at 1.5 times the regular hourly wage rate. Some states, like California, also calculate daily overtime for hours worked over 8 hours in a single workday.

How do you calculate hours worked crossing midnight?

When a shift crosses midnight, add 24 hours (1440 minutes) to the end time before subtracting the start time. For example, if you start at 10:00 PM (22:00) and finish at 6:00 AM (06:00), the difference is (6 + 24) - 22 = 8 hours worked.

How Many Hours Am I Working Calculator

How Many Hours Am I Working?

If you're asking yourself "how many hours am I working?", you are not alone. Tracking shift hours, deducting breaks, and logging work sessions are crucial activities for anyone paid hourly, filing timesheets, or invoicing clients.

Our interactive How Many Hours Am I Working Calculator does the hard calculations for you. By entering your daily start and end times, along with unpaid breaks, you get your total duration and its decimal equivalent immediately. This prevents keying errors, simplifies your invoicing, and ensures you get paid for every minute on the clock.

How to Calculate Hours Worked (Step-by-Step)

Calculating your work hours manually follows a simple arithmetic sequence, though converting standard minutes to decimals can be tricky. Here is the formula:

1

Record Start and End Times Note down the exact times you clocked in and out. For example, starting at 8:30 AM and leaving at 5:00 PM.

2

Find Total Shift Length Calculate the time between those points. From 8:30 AM to 5:00 PM is exactly 8 hours and 30 minutes (510 minutes).

3

Deduct Unpaid Breaks Subtract lunch or break periods. If you had a 30-minute break: 8 hours 30 minutes minus 30 minutes = 8 hours worked.

4

Convert to Decimal Hours for Payroll Divide your remaining minutes by 60 and add to the hours. 8 hours + (0 minutes ÷ 60) = 8.00 decimal hours.

Net Hours = (End Time − Start Time) − Break Time Example: Start 8:00 AM, End 4:30 PM with 30m break: 8h 30m shift − 30m = 8h 00m worked (8.00 decimal hours)

📊 Excel Formula: Hours Worked Between Two Times

To calculate total decimal hours worked between a Start Time (e.g., cell A1 = 8:00 AM) and End Time (e.g., cell B1 = 4:30 PM) while deducting a lunch break (e.g., cell C1 = 30 minutes) in Excel or Google Sheets, use this formula:

=MOD(B1-A1,1)*24 - (C1/60)

Why the MOD function? Using MOD(B1-A1,1) ensures that if your shift crosses midnight (e.g., starting at 10 PM and leaving at 6 AM), Excel will still calculate the overnight hours worked perfectly without errors.

Federal Compliance and Lunch Breaks (FLSA Rules)

According to the **U.S. Department of Labor (DOL)** under the **Fair Labor Standards Act (FLSA)**, rest breaks of short duration (usually 5 to 20 minutes) must be counted as paid hours worked. However, bona fide meal periods (typically lasting 30 minutes or longer) do not have to be paid, provided the employee is completely relieved from duty for the purpose of eating regular meals.

Why You Need Decimal Hours

Most modern payroll and accounting systems (like ADP, QuickBooks, Gusto, and FreshBooks) cannot calculate wages using hours and minutes directly. For example, if you work 7 hours and 45 minutes at a rate of $20.00/hour, you cannot simply multiply 7:45 × 20 in a spreadsheet. You must first convert 45 minutes into its decimal value (45 ÷ 60 = 0.75), yielding 7.75 decimal hours. Then, the math is simple: 7.75 × $20 = $155.00.

Our tool makes this conversion automatic and handles standard rounding requirements.

Common Work Shift Examples

Start Time	End Time	Unpaid Break	Total Hours worked	Decimal Hours
9:00 AM	5:00 PM	30 min	7h 30m	7.50
8:00 AM	5:00 PM	1 hour	8h 00m	8.00
8:30 AM	4:30 PM	30 min	7h 30m	7.50
7:00 AM	3:30 PM	30 min	8h 00m	8.00
9:00 AM	6:00 PM	45 min	8h 15m	8.25
10:00 PM	6:00 AM	None	8h 00m	8.00

Frequently Asked Questions

Quick answers to common questions about calculating work hours, shift lengths, and unpaid breaks.

How do I calculate how many hours I worked?

To calculate your net hours worked, subtract your start time from your end time, then deduct any unpaid lunch breaks. For example, a shift from 9:00 AM to 5:30 PM represents a total elapsed duration of 8.5 hours. Deducting a 30-minute unpaid lunch break (0.50 decimal hours) leaves exactly 8.00 decimal hours worked.

What is the decimal equivalent of a 30-minute break?

A 30-minute break represents exactly 0.50 decimal hours. It is calculated by dividing 30 minutes by 60 (30 ÷ 60 = 0.50). Similarly, a 15-minute rest break represents 0.25 hours, and a 45-minute lunch break represents 0.75 decimal hours.

How is weekly overtime calculated?

Under United States federal law (FLSA), standard weekly overtime is calculated as any hours worked over 40 hours in a single 168-hour workweek. Overtime hours must be compensated at a rate not less than 1.5× the regular hourly wage rate. Some states (like California) enforce strict daily overtime, where hours worked beyond 8 in a single workday are also paid at 1.5× (and over 12 hours at 2.0×).

How do you calculate hours worked for shifts crossing midnight?

When a work shift crosses midnight, add 24 hours to your end time before subtracting your start time. For example, if you start work at 10:00 PM (22:00) and finish at 6:00 AM (06:00) the following morning, the elapsed time is (6 + 24) − 22 = 8.00 hours. Our digital calculator automatically detects overnight shifts and applies this rule instantly.