QuickBooks Time Card Calculator: Hours & Pay

This calculator works out total hours worked and gross pay from QuickBooks-style time card entries. You enter the start time, end time, and hourly rate for each shift, and it returns the daily total in hours and minutes, the weekly total, and the gross pay before deductions. It uses the standard formula: pay = total hours × hourly rate, with overtime handled separately if you choose to include it.

Formula

The calculator uses two basic formulas. First, total hours worked: Total hours = End time − Start time (both in decimal hours, where 9.0 = 9:00 AM and 17.5 = 5:30 PM). Second, gross pay: Gross pay = (Regular hours × hourly rate) + (Overtime hours × hourly rate × overtime rate).

Variables:

• Start time (t) – clock-in time in decimal hours (0–24).
• End time (d) – clock-out time in decimal hours (0–24).
• Hourly rate (r) – base pay per hour in dollars.
• Overtime rate (o) – multiplier for hours beyond the regular threshold (typically 1.5).
• Regular hours before OT (h) – the number of hours in a shift that count as regular time (often 8).

If you do not want overtime, set the overtime rate to 1.0 and the regular hours to a very large number (like 24), so all hours are paid at the base rate.

Worked Example

Using the default values from the calculator: start at 9:00 AM (9.0), end at 5:30 PM (17.5), hourly rate $20, overtime rate 1.5, regular hours 8.

1. Total hours = 17.5 − 9.0 = 8.5 hours.
2. Regular hours = min(8.5, 8) = 8 hours.
3. Overtime hours = max(0, 8.5 − 8) = 0.5 hours.
4. Regular pay = 8 × $20 = $160.00.
5. Overtime pay = 0.5 × $20 × 1.5 = $15.00.
6. Gross pay = $160.00 + $15.00 = $175.00.

The calculator shows 8.50 total hours, 0.50 overtime hours, $160.00 regular pay, $15.00 overtime pay, and $175.00 gross pay.

How QuickBooks Time Cards Actually Work

QuickBooks Time (formerly TSheets) is a time-tracking app that records clock-in and clock-out timestamps. When you run payroll, QuickBooks calculates hours by subtracting the start timestamp from the end timestamp, then converts minutes to decimal hours (e.g., 15 minutes = 0.25 hours). The app also lets you assign pay rates per employee or per job, and it applies overtime rules you configure (daily, weekly, or by state).

This calculator mimics that logic for a single shift. For a full week, you would add up each day’s hours and then apply weekly overtime if your state or company uses that rule. QuickBooks can also handle multiple pay rates, tips, and bonuses, which this simple tool does not.

Common Mistakes When Calculating Time Cards

• Using 12-hour time without AM/PM – 1:00 PM entered as 1.0 gives 1 hour, not 13 hours. Always convert to 24-hour or decimal.
• Forgetting to convert minutes to decimal – 8:30 is 8.5, not 8.3. Divide minutes by 60.
• Ignoring overnight shifts – If an employee clocks in at 11 PM and out at 7 AM, the simple subtraction gives a negative number. Add 24 to the end time if it is smaller than the start.
• Not applying overtime correctly – Some states require daily overtime after 8 hours, others weekly after 40. Know which rule applies to you.
• Rounding errors – Always round to the nearest quarter-hour or hundredth, depending on your payroll policy.

How to Choose the Right Time Card Method

For a small business with a few employees, a simple spreadsheet or this calculator works fine. For larger teams, you need a system that tracks time automatically. Consider these factors:

• Number of employees – More than 10 makes manual entry error-prone.
• Overtime complexity – If you pay different rates for different jobs, you need software that handles cost codes.
• Remote vs. on-site – Mobile apps with GPS are useful for field workers.
• Integration with payroll – QuickBooks Time integrates directly with QuickBooks Payroll, saving re-entry.
• Budget – Free tools exist, but paid plans offer more automation.

QuickBooks Time vs. Manual Spreadsheets

QuickBooks Time automatically records timestamps, which prevents “buddy punching� and forgotten entries. It also generates reports by employee, job, or project, and exports directly to payroll. A spreadsheet requires manual entry, which is time-consuming and prone to typos. However, spreadsheets are free and flexible. For a one-person business, a spreadsheet is often enough. For a growing company, the time saved by automation usually justifies the cost.

Cost and Setup Considerations

QuickBooks Time offers a free trial, then a per-user monthly fee (the exact price changes, so check the current plan). It also requires a QuickBooks Payroll subscription for full payroll integration. Setup involves creating employee profiles, setting pay rates, and defining overtime rules. The mobile app lets employees clock in from their phones. There is no long-term contract on most plans, so you can cancel anytime.

Alternatives to QuickBooks Time Card Calculator

• Excel or Google Sheets – Free, but manual.
• Clockify – Free time tracker with unlimited users.
• Toggl Track – Good for freelancers and small teams.
• Deputy – Includes scheduling and time clock features.
• Homebase – Free plan for hourly workers.

Each has different strengths. This calculator is best for quick, one-off calculations without signing up for anything.

Frequently Asked Questions

How do I convert 7:30 AM to decimal hours?

Take the hour (7) and add the minutes divided by 60: 30/60 = 0.5, so 7:30 AM = 7.5. For PM times, add 12 to the hour (except 12 PM itself). So 5:30 PM = 17.5.

What if my employee works overnight?

Add 24 to the end time if it is smaller than the start time. For example, 11 PM (23.0) to 7 AM (7.0): 7.0 + 24 = 31.0, then 31.0 − 23.0 = 8 hours.

Does this calculator handle lunch breaks?

No. You must subtract the unpaid break manually. For example, if the shift is 9 to 5 with a 30-minute lunch, total paid hours = 8 − 0.5 = 7.5. Enter 8.0 as the end time and then subtract 0.5 from the result.

What is the difference between overtime and double time?

Overtime is usually 1.5× the hourly rate, while double time is 2×. Some states require double time after 12 hours in a day or after a certain number of consecutive days. You can set the overtime rate to 2.0 in this calculator for double time.

Is QuickBooks Time free?

QuickBooks Time offers a free trial, but it is a paid subscription after that. The price depends on the number of users and the plan level. There is no permanent free tier.

Can I use this calculator for salaried employees?

No. Salaried employees are paid a fixed amount regardless of hours. This calculator is only for hourly workers.

Related

• Duration Calculator Hours: How to Use It
• Dog Years Calculator: How to Convert
• Dog Years to Human Years: Real Age Chart

in t | Start time (HH:MM 24h) | - | 9.0 | 0
in d | End time (HH:MM 24h) | - | 17.5 | 0
in r | Hourly rate ($) | - | 20 | 0
in o | Overtime rate (× normal) | - | 1.5 | 0
in h | Regular hours before OT | h | 8 | 0
out hours | Total hours | h | (d - t) | 2
out ot_hours | Overtime hours | h | max(0, (d - t) - h) | 2
out reg_pay | Regular pay | $ | (min((d - t), h) * r) | 2
out ot_pay | Overtime pay | $ | (max(0, (d - t) - h) * r * o) | 2
out gross | Gross pay | $ | (min((d - t), h) * r) + (max(0, (d - t) - h) * r * o) | 2