Horas

How to calculate hours worked, with lunch and decimals

Quick answer

To learn how to calculate hours worked, subtract your start time from your end time and take out unpaid breaks: 8:00 AM to 5:30 PM with a 30-minute lunch is 9 hours. Convert the minutes to a decimal (divide by 60) before multiplying by your hourly rate. The calculator below does one day for you.

Updated 4 min readGambit Studio

Hours worked calculator

Leave the break empty if you had none. Shifts that cross midnight work too.

Step by step

  1. Write the times in 24-hour format: add 12 to PM hours (5:30 PM = 17:30). 12 PM stays 12; 12 AM is 0.
  2. Subtract start from end: 17:30 − 8:00 = 9 h 30 min.
  3. Subtract the unpaid break: 9 h 30 min − 30 min = 9 h 00 min.
  4. If the end minutes are smaller than the start minutes, borrow an hour: 17:05 − 8:40 becomes 16:65 − 8:40 = 8 h 25 min.
  5. Convert to decimal hours for pay: 25 ÷ 60 = 0.42, so 8 h 25 min = 8.42 hours.

Which breaks count as hours worked

Under the federal Fair Labor Standards Act, short rest periods, "usually 20 minutes or less," are customarily paid and "must be counted as hours worked." Bona fide meal periods, "typically 30 minutes or more," generally don't count, as long as you are completely relieved from duty (U.S. Department of Labor, Fact Sheet #22). State law can add rules on top of this.

A week of hours, worked out

DayInLunchOutHoursDecimal
Mon8:00 AM30 min5:30 PM9:009.00
Tue8:40 AM30 min5:05 PM7:557.92
Wed7:00 AM60 min5:00 PM9:009.00
Thu9:00 AMnone1:15 PM4:154.25
Fri10:00 PM30 min6:30 AM8:008.00
Week38:1038.17

Friday crosses midnight: from 10:00 PM to 6:30 AM is 8 h 30 min (add 24 hours to the end time when it is earlier than the start), minus the 30-minute lunch.

Hours worked and pay

Pay = decimal hours × hourly rate. At $18 an hour, 38 h 10 min (38.17 hours) is $687.00. For nonexempt employees under the FLSA, hours over 40 in a workweek must be paid at least one and one-half times the regular rate (DOL Fact Sheet #22): 44 hours at $18 is 40 × $18 + 4 × $27 = $828. For any minute, the minutes to decimal chart has the conversion.

In Excel or Google Sheets

  • Start in B2, lunch out in C2, lunch in D2, end in E2. Hours for the day: =(C2-B2)+(E2-D2)
  • Overnight shift with no break: =MOD(E2-B2,1)
  • Decimal hours: =F2*24; pay: =F2*24*$H$1 with the rate in H1.
  • Weekly total: =SUM(F2:F8) with the custom format [h]:mm, so totals above 24 hours don't roll over (Microsoft).

The app we're building

What the app will do that this page can't: We're building Hours Calculator, a personal time card app for iPhone that will keep every day on your iPhone, total the week and the month on its own, show overtime with the estimated pay from your hourly rate and export a PDF time card, with no account and no internet. It is not on the App Store yet: leave your email and we will tell you when it launches.

Sources

  1. U.S. Department of Labor, Wage and Hour Division: Fact Sheet #22, Hours Worked Under the FLSA (revised July 2008)
  2. Microsoft Support: Add or subtract time in Excel

Frequently asked questions

What people ask most about this, answered with the source.

How many hours did I work if I worked 7am to 5pm?
7 AM to 5 PM is 10 hours. Take out unpaid breaks: with a 30-minute lunch it is 9.5 hours; with a 1-hour lunch, 9 hours.
How do I calculate hours worked with a lunch break?
Subtract the start time from the end time, then subtract the lunch: 8:00 to 17:30 is 9 h 30 min; minus a 30-minute lunch, 9 hours. Bona fide meal periods of 30 minutes or more generally aren't hours worked under the FLSA.
How do I calculate hours worked in decimals?
Divide the minutes by 60 and add them to the hours: 7 h 45 min = 7 + 45 ÷ 60 = 7.75 hours.
How do I calculate hours worked in Excel?
Use =(C2-B2)+(E2-D2) for a day with a break, =MOD(E2-B2,1) for overnight shifts, multiply by 24 for decimal hours and format weekly totals as [h]:mm.
How many hours did I work this week?
Add up each day's hours after breaks. Convert every day to decimal first (8 h 25 min = 8.42) so the total is easy to multiply by your rate.
Is a 15-minute break counted as hours worked?
Under the FLSA, short rest periods of usually 20 minutes or less are customarily paid and must be counted as hours worked (DOL Fact Sheet #22).
HorasComing soon to the App Store
Notify me at launch