Timesheet Calculator
Quickly calculate your total hours and gross pay for the week.
Understanding Your Timesheet
Whether you're an hourly employee double-checking your paycheck, a freelancer tracking billable hours, or a small business owner managing payroll, accuracy in your timesheet is crucial. A simple error of just 15 minutes a day can add up to dozens of unpaid hours over a year. Our timesheet calculator is designed to provide quick, accurate calculations for your weekly hours and estimated gross pay.
How to Calculate Hours Worked
Calculating your total hours worked isn't as simple as counting the hours you were in the building. It requires converting your clock-in and clock-out times into decimal formats, calculating the duration of your shift, and properly deducting unpaid breaks.
1. The 24-Hour Clock Conversion
The first step in calculating duration is converting your standard 12-hour AM/PM times into a 24-hour format (military time). This prevents mathematical errors when crossing the noon threshold.
- For AM times, the hour remains the same (e.g., 9:00 AM is 09:00).
- For PM times, add 12 to the hour (e.g., 5:00 PM becomes 17:00).
2. Converting Minutes to Decimals
This is where most mistakes happen. Payroll systems do not process time in minutes; they process time in hundredths of an hour (decimals). You cannot simply write down "8.30" for 8 hours and 30 minutes, because 30 minutes is half an hour, meaning the correct decimal is 8.5.
To convert minutes to a decimal, divide the minutes by 60.
Decimal Hours = Minutes / 60 Common conversions include:
- 15 minutes = 0.25 hours
- 30 minutes = 0.50 hours
- 45 minutes = 0.75 hours
3. Subtracting Unpaid Breaks
Under the Fair Labor Standards Act (FLSA) in the United States, short breaks (usually 5 to 20 minutes) are considered compensable work hours. However, bona fide meal periods (typically 30 minutes or more) where the employee is completely relieved of duty do not count as work time.
When calculating your timesheet, you must deduct these unpaid breaks from your total shift duration.
Step-by-Step Example Calculation
Let's walk through a typical workday to see the math in action:
- Clock-In: 8:30 AM
- Clock-Out: 5:15 PM
- Unpaid Lunch: 45 minutes
Step 1: Convert to 24-hour time
- 8:30 AM = 08:30
- 5:15 PM = 17:15
Step 2: Calculate total elapsed time
First, subtract the hours: 17 - 8 = 9 hours.
Then, subtract the minutes: 15 - 30 = -15 minutes.
Since we have a negative minute value, we borrow 1 hour (60 minutes) from the hour total.
9 hours becomes 8 hours.
-15 minutes + 60 minutes = 45 minutes.
The total shift duration is 8 hours and 45 minutes.
Step 3: Convert to decimal
45 minutes / 60 = 0.75 hours. The total duration is 8.75 hours.
Step 4: Deduct the break
The unpaid break was 45 minutes. We convert this to decimal: 45 / 60 = 0.75 hours.
Now, subtract the break from the total duration: 8.75 hours - 0.75 hours = 8.00 billable hours.
Calculating Gross Pay
Gross pay is the total amount of money you earn before taxes, insurance premiums, retirement contributions, or other deductions are withheld from your paycheck.
Gross Pay = Total Billable Hours × Hourly Rate If you worked 40 hours in a week and your hourly rate is $18.50, your gross pay is:
40 × $18.50 = $740.00
What About Overtime?
It is important to note that our calculator currently provides a straight-time gross pay estimate. It does not automatically calculate time-and-a-half for overtime hours. Federal law in the US mandates that non-exempt employees receive 1.5 times their regular rate of pay for any hours worked over 40 in a single workweek. Some states, like California, also have daily overtime laws (e.g., overtime pay for any hours worked beyond 8 in a single day). If you work overtime, your actual gross pay will be higher than a straight-time calculation.
Tips for Accurate Time Tracking
- Track daily, not weekly: Memory fades. If you wait until Friday to fill out your timesheet for Monday, you are likely to guess incorrectly, which can shortchange you or your employer.
- Be precise: Don't round to the nearest hour if your employer tracks time by the minute or quarter-hour. If you clocked out at 5:08 PM, write down 5:08 PM.
- Understand your employer's rounding policy: The FLSA allows employers to round employee time to the nearest quarter hour (15-minute increments), provided that the rounding averages out and doesn't continually disadvantage the employee. For example, clocking in at 8:07 AM could be rounded to 8:00 AM, while clocking in at 8:08 AM could be rounded to 8:15 AM.
Frequently Asked Questions
How do you calculate total hours worked?
To calculate total hours worked, find the difference between your clock-in time and clock-out time. First convert the times to a 24-hour clock. Then subtract the start time from the end time. Finally, subtract any unpaid break time (converted to decimals) from that total duration.
How are minutes converted to decimals for payroll?
For payroll, minutes must be divided by 60 to calculate the decimal equivalent of an hour. For example, 15 minutes is 15/60 = 0.25 hours, 30 minutes is 0.5 hours, and 45 minutes is 0.75 hours. You cannot simply use minutes as the decimal (e.g., 8 hours and 30 minutes is 8.5, not 8.30).
What is gross pay?
Gross pay is your total earnings before any taxes, garnishments, or deductions are taken out. It is calculated by multiplying your total hours worked by your hourly rate.
Should breaks be deducted from timesheets?
It depends on labor laws and employer policies. Under federal law in the US, short breaks (typically 5-20 minutes) must be paid. However, longer, bona fide meal breaks (30+ minutes) where you are fully relieved of duties are typically unpaid and should be deducted from your total work hours.
How is overtime calculated?
In the US, under federal law, overtime is generally calculated as time-and-a-half (1.5 times the regular hourly rate) for any hours worked over 40 in a standard workweek. Some states also have laws mandating overtime pay for hours worked beyond a certain threshold in a single day.