How do I calculate timesheet hours?

Subtract your clock-in time from your clock-out time, then deduct any break time. For example, if you clock in at 9:00 AM and clock out at 5:30 PM with a 30-minute lunch, your net hours are 8 hours (8.5 hours − 0.5 hours break). Convert to decimal by dividing remaining minutes by 60.

What is the difference between weekly and biweekly timesheets?

A weekly timesheet covers 7 days (one work week), while a biweekly timesheet covers 14 days (two work weeks). Biweekly is the most common pay period in the US — about 36.5% of private employers use it, according to BLS data. Overtime is calculated per week even on biweekly timesheets.

How do I convert timesheet minutes to decimal hours?

Divide the minutes by 60. Common conversions: 15 min = 0.25, 30 min = 0.50, 45 min = 0.75. For example, 7 hours 45 minutes = 7.75 decimal hours. Most payroll systems require decimal format for accurate pay calculation.

Does this timesheet calculator handle overnight shifts?

Yes. If the clock-out time is earlier than the clock-in time, the calculator automatically detects an overnight shift and adds 24 hours. For example, a shift from 10:00 PM to 6:00 AM is correctly calculated as 8 hours. Overnight shifts are marked with a moon icon in the breakdown.

How do I enter afternoon or evening times?

The time picker uses a 12-hour AM/PM format. Select the hour, minute, then tap PM for afternoon and evening shifts. For example, 1:00 PM is equivalent to 13:00 military time. The calculator stores times internally in 24-hour format and handles all conversions automatically.

How do I calculate a timesheet in Excel?

Use the formula =B2-A2-C2 where A2 is clock-in time, B2 is clock-out time, and C2 is break duration. Format the result cell as [h]:mm to display totals over 24 hours correctly. To convert to decimal hours, multiply by 24: =(B2-A2-C2)*24. For 15-minute rounding with lunch, use =MROUND((B2-A2-C2)*24, 0.25). For overnight shifts with lunch, use =IF(B2<A2, B2+1, B2)-A2-C2 to correctly handle midnight crossing plus break deduction. While Excel works for basic calculations, an online timesheet calculator saves setup time and handles edge cases like rounding, overtime, and auto-breaks automatically.

How do you calculate 45 minutes on a timesheet?

45 minutes equals 0.75 decimal hours (45 ÷ 60 = 0.75). For example, a shift of 8 hours and 45 minutes = 8.75 decimal hours. Under 15-minute rounding, 45 minutes is exactly three quarter-hour increments, so no rounding adjustment is needed — it's already a clean 0.75. For tenth-hour (6-minute) rounding, 45 minutes rounds halfway up to 48 minutes (8 × 6), which equals 0.80 decimal hours.

Timesheet Calculator

Pay Period

Week Starts On

Time Rounding (rounds net hours)

Auto Lunch

Overtime

Calculate Pay

Start

End

Break

Sun

Mon

Tue

Wed

Thu

Fri

Sat

··

Total Hours

37.50hrs

37h 30m (37:30 HH:MM)

5days worked

Daily Breakdown

5 days, 37.50 hours

Day	In	Out	Break	Hours
Sunday	—	—	—	—
Monday	09:00	17:00	30m	7.50
Tuesday	09:00	17:00	30m	7.50
Wednesday	09:00	17:00	30m	7.50
Thursday	09:00	17:00	30m	7.50
Friday	09:00	17:00	30m	7.50
Saturday	—	—	—	—
Total				37.50

How It Works

Convert clock-in/out times to payroll-ready decimal hours

This timesheet calculator converts your daily clock-in and clock-out times into total work hours with support for weekly and biweekly pay periods, automatic lunch deduction, payroll-style time rounding, and overtime calculation.

Core Formula

Net Hours = (Clock Out − Clock In) − Break Minutes ÷ 60

Weekly & Biweekly

7 or 14-day periods with per-week subtotals

Auto Lunch

Replaces manual break for shifts over a set threshold

Time Rounding

5, 6, or 15-minute payroll rounding modes

Overnight Shifts

Auto-detects shifts crossing midnight

Worked Example

Input

Clock In: 9:00 AM

Clock Out: 5:30 PM

Break: 30 min

Result

Duration: 8h 0m

Decimal: 8.00 hrs

8.5h − 0.5h break

How to Use the Timesheet Calculator

Step-by-step instructions to calculate your work hours

Choose your pay period

Select Weekly (7 days, one row per day) or Biweekly (14 days, two weeks with per-week subtotals) from the dropdown.

Enter clock-in and clock-out times

For each working day, use the time picker to enter when you started and ended your shift. Skip days you didn't work — they are excluded from totals automatically. Overnight shifts (e.g., 10:00 PM → 6:00 AM) are detected and handled correctly.

Set break time (lunch)

Enter your lunch or break duration in minutes for each day, or toggle Auto Lunch to have the calculator automatically deduct a set break amount (e.g., 30 minutes) for any shift exceeding a threshold (e.g., 6 hours). When auto lunch is on, qualifying shifts show a non-editable break label.

Choose a rounding mode (optional)

Select 5-minute, 6-minute (1/10th hour), or 15-minute (quarter-hour) rounding. This rounds your net daily hours (after subtracting breaks). Leave as None for exact times.

Configure overtime and pay (optional)

Set your overtime method (weekly/daily), threshold, and rate multiplier. Enter an hourly rate to see gross pay alongside total hours.

Review your totals

The calculator displays total hours in decimal and HH:MM format, a daily breakdown, overtime hours, and gross pay if an hourly rate is entered.

How to Calculate Timesheet Hours Manually

The step-by-step formula with a worked example

Manual Timesheet Formula

Net Hours = (Clock Out − Clock In) − (Break Minutes ÷ 60)

Worked Example

Let's calculate hours for a 9:00 AM to 5:30 PM shift with a 30-minute lunch break:

Step 1: Total elapsed time5:30 PM − 9:00 AM = 8h 30m

Step 2: Convert to decimal8h 30m = 8.50 hours

Step 3: Subtract break30 min ÷ 60 = 0.50 hours

Net hours8.50 − 0.50 = 8.00 hours

Excel Timesheet Formula

How to set up a timesheet in Microsoft Excel or Google Sheets

You can build a basic timesheet in Excel or Google Sheets using simple formulas. While an online calculator handles rounding, overtime, and breaks automatically, here is the core formula to calculate daily hours from clock-in and clock-out times:

Cell	Example	Description
A2	9:00 AM	Clock-in time
B2	5:30 PM	Clock-out time
C2	0:30	Lunch break (0h 30m)
D2	=B2-A2-C2	Net hours (format as [h]:mm)

Key Excel Tips

[h]:mm

Format cells

Use [h]:mm (not h:mm) so totals over 24 hours display correctly without rolling into days.

× 24

Decimal hours

Multiply by 24 to convert to decimal: =(B2-A2-C2)*24 → 8.00

MROUND

15-min rounding

=MROUND((B2-A2-C2)*24, 0.25) (includes lunch break deduction)

OVERNIGHT

Overnight shifts

=IF(B2<A2, B2+1, B2)-A2-C2 (handles midnight crossing + lunch)

Time Rounding for Payroll

How employers round timesheet entries and FLSA compliance rules

This calculator rounds the net daily duration (clock-out minus clock-in minus breaks). This is different from punch rounding, which rounds each clock-in and clock-out time separately. Under FLSA rules, employers may round clock times to the nearest 5, 6, or 15 minutes — but the rounding must average out fairly and cannot consistently favor the employer.

15
Quarter-Hour Rounding

Rounding to 0, 15, 30, or 45 minutes. Commonly used in US payroll. Each 15 minutes = 0.25 hours.

7h 7m → 7.00h7h 8m → 7.25h

6
Tenth-Hour Rounding

Popular with law firms and consulting. Each 6 minutes = 0.1 hours. Provides finer billing granularity.

7h 18m → 7.3h7h 24m → 7.4h

5
Five-Minute Rounding

Finer granularity for employers wanting less rounding error. 12 increments per hour.

7h 22m → 7h 20m7h 23m → 7h 25m

FLSA ComplianceUnder 29 CFR § 785.48, employers may round clock-in and clock-out times to the nearest 5, 6, or 15 minutes. This calculator rounds net daily duration (after subtracting breaks) — not individual clock times. If your employer uses punch rounding, the result may differ slightly. Rounding must average out fairly over time and cannot consistently shortchange employees.

Minutes to Decimal Conversion

Quick reference chart for converting timesheet minutes to decimal hours

Payroll systems require decimal hours rather than hours and minutes. Divide minutes by 60 to convert.

Decimal Hours = Minutes ÷ 60

Minutes	Decimal	Minutes	Decimal
5 min	0.08	35 min	0.58
10 min	0.17	40 min	0.67
15 min	0.25	45 min	0.75
20 min	0.33	50 min	0.83
25 min	0.42	55 min	0.92
30 min	0.50	60 min	1.00

7h 15m

7.25h

7h 30m

7.50h

7h 45m

7.75h

Overtime Rules

Federal FLSA standard vs state-specific daily overtime laws

Overtime laws vary by jurisdiction. This calculator supports both major methods with configurable thresholds and multipliers.

Weekly (FLSA)

Federal standard. Hours over 40 per week paid at 1.5× rate.

42h week: 40h regular + 2h OT

Used by most US states

Daily (e.g., California)

Some states require OT after 8 hours per day, regardless of weekly total. Rules vary by state.

10h day: 8h regular + 2h OT

Check your state labor laws

Pay Calculation

1.5×

Time and a half — Standard OT rate. $20/hr → $30/hr OT.

2.0×

Double time — CA after 12h/day or 7th consecutive day. $20/hr → $40/hr. This calculator supports one OT tier at a time; for multi-tier state rules, calculate each tier separately.

Common Mistakes

Rounding time to always favor employer

Rounding must be neutral over time (FLSA)

Skipping lunch breaks on long shifts

Many states require meal breaks after 5-6 hours — check your state and local rules

Using HH:MM math for payroll (1:30 ≠ 1.30)

Convert to decimal first: 1h 30m = 1.50h

Assuming OT is always weekly

Some states have daily OT — check your state laws

Frequently Asked Questions

Common questions and detailed answers

This calculator rounds the net daily duration (clock-out minus clock-in minus breaks) to the nearest 5, 6, or 15 minutes. For example, a 7h 7m shift rounds to 7.00h in 15-min mode, while 7h 8m rounds to 7.25h. This differs from punch rounding, where employers round each clock-in and clock-out time individually. Under FLSA rules (29 CFR § 785.48), any rounding must average out fairly and cannot consistently shortchange employees.

When enabled, auto lunch automatically applies a lunch break (e.g., 30 minutes) for any shift exceeding a configurable threshold (e.g., 6 hours). It replaces the manual break for qualifying shifts — the break column shows the auto-deducted amount and becomes non-editable. Shorter shifts that don't meet the threshold still allow manual break entry. Many US states require meal breaks for shifts over 5–6 hours, making this feature convenient for tracking expected breaks; verify your state and local rules for compliance.

Under federal FLSA rules, overtime kicks in after 40 hours per week at 1.5× your regular rate. Some states like California use daily overtime — hours over 8 per day are overtime regardless of weekly total. This calculator supports both methods with adjustable thresholds. Note: it handles one overtime tier at a time; for multi-tier state rules (e.g., California's 1.5× after 8h and 2× after 12h), calculate each tier separately.

15 minutes equals 0.25 decimal hours. To calculate 15 minutes on a timesheet, divide 15 by 60 (15 ÷ 60 = 0.25). For example, 7 hours and 15 minutes = 7.25 decimal hours. This calculator rounds net daily hours to the nearest 5, 6, or 15 minutes. For instance, a 7h 7m shift rounds down to 7.00h, while 7h 8m rounds up to 7.25h in 15-minute mode. Some employers use punch rounding (rounding each clock-in/out time individually), which may yield slightly different results.

Subtract your lunch break duration from the total elapsed time between clock-in and clock-out. For example, if you work from 8:00 AM to 5:00 PM (9 hours elapsed) with a 30-minute lunch, your net hours are 9.00 − 0.50 = 8.50 hours. With this calculator, enter your break minutes manually per day, or enable Auto Lunch to automatically deduct a set amount (e.g., 30 minutes) from any shift exceeding a threshold (e.g., 6 hours). When auto lunch is active, qualifying shifts show the auto-deducted break and become non-editable.

Yes! This is a completely free online time card calculator — no sign-up, no download, and no payment required. Enter your clock-in and clock-out times for each day, set your break duration, choose a pay period (weekly or biweekly), and optionally enter your hourly rate to see gross pay. The calculator supports automatic lunch deductions, payroll-style time rounding (5, 6, or 15 minutes), overtime calculation (both weekly and daily), overnight shift detection, and instant decimal-hour conversion. All calculations run entirely in your browser. Be aware that sharing or bookmarking the URL will include your timesheet inputs in the page address.

Embed Timesheet Calculator

Add this calculator to your website or blog for free.

Explore more calculators

Last updated Jun 18, 2026