Hours worked calculator
Leave the break empty if you had none. Shifts that cross midnight work too.
Step by step
- 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.
- Subtract start from end: 17:30 − 8:00 = 9 h 30 min.
- Subtract the unpaid break: 9 h 30 min − 30 min = 9 h 00 min.
- 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.
- 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
| Day | In | Lunch | Out | Hours | Decimal |
|---|---|---|---|---|---|
| Mon | 8:00 AM | 30 min | 5:30 PM | 9:00 | 9.00 |
| Tue | 8:40 AM | 30 min | 5:05 PM | 7:55 | 7.92 |
| Wed | 7:00 AM | 60 min | 5:00 PM | 9:00 | 9.00 |
| Thu | 9:00 AM | none | 1:15 PM | 4:15 | 4.25 |
| Fri | 10:00 PM | 30 min | 6:30 AM | 8:00 | 8.00 |
| Week | 38:10 | 38.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$1with 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.