Guide
Use this time card calculator to total hours for a weekly time card or timesheet. Enter when you clocked in, left for lunch, returned and clocked out. It calculates daily and weekly hours, separates regular and overtime hours, and can calculate gross pay.
How to use the time card calculator
- Choose the day your workweek starts: Sunday or Monday. Use your employer's workweek.
- Enter Time In, Lunch Out, Lunch In and Time Out for each day you worked.
- Leave Lunch Out and Lunch In blank if you did not clock out for lunch. You can subtract a fixed unpaid lunch instead.
- Use Break for other unpaid time, such as 15 minutes.
- Add your hourly rate if you want gross pay.
- Press Copy for Excel to paste the card into a spreadsheet.
Optional: choose a date in Week of to add dates to each day.
Example: a week with overtime
This week starts on Sunday, which is a day off. The calculator produced the hours below.
| Day | Time In | Lunch Out | Lunch In | Time Out | Hours |
|---|---|---|---|---|---|
| Monday | 8:58 AM | 12:02 PM | 12:31 PM | 5:34 PM | 8:07 (8.12) |
| Tuesday | 9:00 AM | 12:00 PM | 12:30 PM | 6:15 PM | 8:45 (8.75) |
| Wednesday | 8:52 AM | 12:15 PM | 12:45 PM | 5:30 PM | 8:08 (8.13) |
| Thursday | 9:05 AM | 1:00 PM | 1:30 PM | 7:10 PM | 9:35 (9.58) |
| Friday | 9:00 AM | 12:00 PM | 1:00 PM | 5:00 PM | 7:00 (7.00) |
| Saturday | 9:00 AM | 1:00 PM | 4:00 (4.00) |
The week totals 45:35 (45.58 hours). The first 40 hours are regular. The remaining 5:35 (5.58 hours) is overtime.
At $18.50 an hour, regular pay is $740.00 and overtime pay is $154.94. Gross pay is $894.94.
How weekly overtime works
Under the federal Fair Labor Standards Act (FLSA), overtime is based on the workweek. 29 U.S.C. 207(a)(1) says an employer may not employ an employee covered by the law "for a workweek longer than forty hours unless such employee receives compensation for his employment in excess of the hours above specified at a rate not less than one and one-half times the regular rate at which he is employed."
This calculator counts overtime as the hours over 40 in one workweek. Exactly 40:00 is not overtime. 40:01 has one minute of overtime.
Each workweek stands alone. 29 CFR 778.104 states: "The Act takes a single workweek as its standard and does not permit averaging of hours over 2 or more weeks." If you work 30 hours one week and 50 the next, the second week still has 10 hours of overtime.
The FLSA has no daily overtime rule. A long day by itself is not overtime under the FLSA. Only the weekly total over 40 counts.
The FLSA also does not require extra pay for weekend or holiday work, unless those hours take the week over 40. See U.S. Department of Labor, Overtime Pay.
What this calculator does not cover:
- State overtime rules. They are not included.
- Exempt jobs. The calculator does not check whether your job is exempt from overtime.
- Other pay. It uses your hourly rate as the rate for overtime. Bonuses, tips and other pay are not included.
Your workweek and overnight shifts
29 CFR 778.105 defines a workweek as a fixed and regularly recurring period of 168 hours, which is seven consecutive 24-hour periods. The rule states: "It need not coincide with the calendar week but may begin on any day and at any hour of the day."
This calculator starts each workweek at 12:00 AM on Sunday or Monday. If your workweek starts at another hour, the split between weeks may differ.
A shift on the last day of the workweek can run past midnight into the next workweek. The hours after midnight count toward the next week.
For example, in a Sunday workweek, a Saturday shift from 10:00 PM to 2:00 AM puts 2:00 in this week and 2:00 in the next week.
This card starts at 12:00 AM on its first day. If last week's final shift ran past midnight, those hours belong to this workweek but are not on this card. Add them to this workweek's total yourself.
Rounding time punches
29 CFR 785.48(b) describes a common practice: "It has been found that in some industries, particularly where time clocks are used, there has been the practice for many years of recording the employees' starting time and stopping time to the nearest 5 minutes, or to the nearest one-tenth or quarter of an hour."
The rule accepts this only with a condition: "For enforcement purposes this practice of computing working time will be accepted, provided that it is used in such a manner that it will not result, over a period of time, in failure to compensate the employees properly for all the time they have actually worked."
This calculator rounds each punch to the nearest 5, 6 or 15 minutes, then totals the time. At the halfway point, it rounds up.
With 15-minute rounding, 8:07 AM becomes 8:00 AM and 8:08 AM becomes 8:15 AM. With 6-minute rounding, 8:03 AM becomes 8:06 AM.
Rounding is off by default. When you turn it on, the totals also show the hours before rounding, so you can compare.
The calculator does not determine which minutes count as work. It totals the times you enter.
How gross pay is calculated
Regular pay is your hourly rate multiplied by your regular hours. Overtime pay is 1.5 times your rate multiplied by your overtime hours.
Hours are counted in whole minutes. Each amount is rounded to the nearest cent, and half a cent rounds up. The overtime rate is not rounded first.
For example, 41:30 at $15.37 an hour: regular pay for 40:00 is $614.80. Overtime pay for 1:30 at 1.5 × $15.37 is $34.58. Gross pay is $649.38.
Gross pay is before taxes and deductions. Tips, bonuses and other pay are not included.
Minutes to decimal hours
Payroll often uses decimal hours. To convert, divide the minutes by 60. For example, 7:45 is 7.75 hours.
| Minutes | Hours | Minutes | Hours |
|---|---|---|---|
| 5 | 0.08 | 30 | 0.50 |
| 6 | 0.10 | 36 | 0.60 |
| 10 | 0.17 | 40 | 0.67 |
| 12 | 0.20 | 42 | 0.70 |
| 15 | 0.25 | 45 | 0.75 |
| 18 | 0.30 | 48 | 0.80 |
| 20 | 0.33 | 50 | 0.83 |
| 24 | 0.40 | 54 | 0.90 |
Time card formulas in Excel
These formulas assume Time In is in B2, Lunch Out in C2, Lunch In in D2 and Time Out in E2, entered as Excel times.
| What to work out | Excel formula |
|---|---|
| Hours for a day with no lunch punches | =MOD(E2-B2,1)*24 |
| Hours for a day with lunch punches | =(MOD(E2-B2,1)-MOD(D2-C2,1))*24 |
| Regular hours for the week (weekly total in F9) | =MIN(F9,40) |
| Overtime hours for the week | =MAX(0,F9-40) |
Excel stores time as a fraction of a day, so multiply by 24 to get hours. MOD handles a Time Out after midnight. To display hours as h:mm instead, leave off the *24 and use the custom format [h]:mm.
Common questions
Does this calculator save my times?
No. Your times and pay rate are calculated in your browser. They are not uploaded, added to the URL or saved. Analytics records only your settings, such as rounding and your workweek start day, the number of days with hours, and whether you copied the results or used the calendar. It never records your times, dates, hours or pay.
Does it handle daily overtime?
No. The FLSA counts overtime by the workweek. State overtime rules are not included.
Can I average two weeks together?
No. Each workweek stands alone. The Department of Labor's Fact Sheet #23 states: "Averaging of hours over two or more weeks is not permitted." Enter one week at a time.
What time formats can I type?
9:00 AM, 9am, 9a, 5:30p, 17:30, 0900, noon and midnight all work. A time like 9 by itself could be AM or PM, so the calculator asks you to add AM or PM. A Time Out earlier than Time In counts as the next day.
How do I enter a day off?
Leave the day blank. You can also type PTO, sick, vacation or off in Time In. These days count as 0 hours worked.
Why is my total different from my paycheck?
Your employer may round punches, start the workweek on another day or subtract breaks differently. Try the rounding and lunch settings to match. Pay can also include things this calculator leaves out, such as bonuses or state overtime rules.
Sources
- 29 U.S.C. 207, Maximum hours
- 29 CFR 778.104, Each workweek stands alone
- 29 CFR 778.105, Determining the workweek
- 29 CFR 785.48, Use of time clocks
- U.S. Department of Labor, Overtime Pay
- U.S. Department of Labor, Fact Sheet #23: Overtime Pay Requirements of the FLSA
Checked on November 3, 2026. This page is a calculator, not legal advice.
