Guides
Worked examples and plain-English explanations for every calculator.
28 guides
All guides
Quick Ways to Solve Math Problems for Timecards and Paychecks
Four formulas let you solve math problems on timecards and paychecks: Decimal hours = whole hours + (minutes ÷ 60). Overtime gross = regular pay for the first 40 hours plus overtime hours × rate × 1.5. Prorated PTO = (full-period accrual ÷ total working days) × days worked. FTE = required hours ÷ standard …
Prorated Salary: Calculate Pay for a Partial Month or Pay Period
Calculate prorated salary using matching pay and time bases. Compare workday and calendar-day examples and check partial-week salary restrictions.
Google Sheets Timesheet: Build a Tracker With Breaks and Weekly Totals
Build a Google Sheets timesheet with validation, unpaid breaks and employee-by-week totals. Copy the formulas and check overnight and incomplete entries.
Weighted Average Overtime: How to Calculate Pay With Multiple Hourly Rates
Calculate a weighted regular rate from multiple hourly rates, then add the overtime premium once. Includes a two-rate example and common payroll errors.
Excel Timesheet Template: Build a Sheet With Breaks and Weekly Totals
Build an Excel timesheet with date-and-time entries, unpaid breaks, decimal hours and weekly totals. Copy the layout and check the worked examples.
Timesheet Control Totals: Reconcile Before Import
Use row counts, employee totals and exception checks to reconcile a timesheet export before importing it into another system.
Convert Decimal Hours to Time in Excel
Convert 7.75 to 7:45 in Excel, preserve totals above 24 hours, and avoid confusing decimal fractions with minutes.
Excel: Show Total Hours Above 24
Fix Excel totals that wrap after 24 hours, keep durations numeric, and check a weekly timesheet with a simple 37:30 example.
How to Calculate Split Shift Hours
Add separate work sessions correctly, exclude the gap once, and distinguish hours worked from the full span of a split shift.
How to Add and Subtract Time Durations by Hand
Add and subtract hours, minutes and seconds by hand. Follow worked examples for durations, breaks, overnight intervals and weekly totals.
12-Hour vs 24-Hour Time: A Practical Conversion Guide
Convert AM and PM to 24-hour time and back. Understand noon, midnight, overnight dates and the difference between clock times and durations.
Seven Common Timesheet Errors and How to Catch Them
Catch seven timesheet errors involving decimal hours, overnight shifts, break deductions, duplicate rows, rounding and missing information.
Convert HH:MM:SS Durations to Decimal Hours
Convert HH:MM:SS durations to decimal hours, including seconds, totals over 24 hours, input validation and common conversion mistakes.
Seconds to Decimal Hours: Formula, Examples and Accuracy Checks
Convert seconds to decimal hours with a simple formula, worked examples, rounding checks and guidance for checking duration totals.
How to Calculate Clock-Out Time with Lunch and Overnight Shifts
Home / Hours & Pay How to Calculate Clock-Out Time with Lunch and Overnight Shifts Calculate a departure time from paid hours and unpaid lunch. Follow same-day and overnight examples, avoid decimal-time mistakes, and check your result.
How to Convert Salary to Hourly Pay with the Right Baseline
Home / Hours & Pay How to Convert Salary to Hourly Pay with the Right Baseline Choose weekly hours and paid weeks before converting salary to hourly pay. Compare part-time schedules, monthly salary and unpaid leave with worked examples.
Monthly Work Hours: Actual Calendar vs. 173.33-Hour Average
Home / Hours & Pay Calculators and Guides Work planning Monthly Work Hours: Actual Calendar vs. 173.33-Hour Average Understand why a month can contain 160, 168, 176 or 184 scheduled hours and when an annual monthly average answers a different question.
Convert a Timesheet Column to Decimal Hours Without Losing the Total
Home / Guides / Topic hub Practical guide Convert a Timesheet Column to Decimal Hours Without Losing the Total Choose one input format, preserve the original durations, and export both row conversions and a reconciled total. This workflow works with a copied column of elapsed times.
Convert Minutes to Decimal Hours in Excel: Formulas & Examples
Home / Hours & pay Excel time conversion Convert Minutes to Decimal Hours in Excel: Formulas & Examples Use the formula that matches your input: minutes, a time duration, or separate hours and minutes.
Check a Decimal-Time CSV Before a Payroll Import
Home / Guides / Hours & Pay Practical guide Check a Decimal-Time CSV Before a Payroll Import Confirm the expected unit, decimal separator, row rounding and treatment of overtime before importing a converted time column.
Why Decimal Hours Totals Differ After Rounding
Home / Guides / Topic hub Practical guide Why Decimal Hours Totals Differ After Rounding Rounding each timesheet row can produce a different total from adding the original durations and rounding once. Compare the two methods before investigating missing time.
Turn Working Days into a Monthly Capacity Budget
Home / Guides / Hours & Pay Practical guide Turn Working Days into a Monthly Capacity Budget Multiply working days by scheduled paid hours, then subtract separately identified unavailable time. Keep scheduled capacity distinct from productive capacity.
How to Count Working Days Between Two Dates
Home / Guides / Hours & Pay Practical guide How to Count Working Days Between Two Dates Count dates on your working weekdays, remove actual closures, and decide whether both endpoints belong in the range before multiplying by daily hours.
How to Subtract Unpaid Breaks from a Timecard
Home / Guides / Hours & Pay Practical guide How to Subtract Unpaid Breaks from a Timecard Deduct time that is genuinely unpaid under the applicable rules and policy. Do not automatically subtract every break from a shift.
How to Calculate an Overnight Shift
Home / Guides / Hours & Pay Practical guide How to Calculate an Overnight Shift When clock-out is earlier than clock-in, add 24 hours to the ending time before subtracting the start and unpaid breaks.
Decimal Hours Conversion Chart and Payroll Examples
Home / Guides / Hours & Pay Practical guide Decimal Hours Conversion Chart and Payroll Examples Convert work hours and minutes to payroll decimals with formulas, a conversion chart, reverse checks and answers for 0.10, 0.50 and 0.80 hours. On this page Convert hours and minutes to decimal hours Use a minutes-to-decimal conversion chart Reconcile …
Shift Differential Pay: Formula and Examples
Home / Guides / Hours & Pay Topic overview Shift Differential Pay: Formula and Examples Calculate flat and percentage shift premiums and understand how eligible hours affect estimated gross pay.
How to Calculate Work Hours Correctly
Home / Guides / Hours & Pay Topic overview How to Calculate Work Hours Correctly A practical guide to calculating worked time, subtracting breaks, handling overnight shifts and converting minutes to decimal hours.
How to use these guides
- Start from the question. Each guide explains one rule — unpaid breaks, overnight shifts, PTO caps, 27-payday years — with a worked example you can check by hand.
- Then run your own numbers. Every guide links to the matching calculator, such as the work hours calculator or three-paycheck months calculator with a 2026/2027 year selector.
- Check the source. Official statistics live in research; Intious-calculated tables in data. Laws differ by state and employer policy decides pay and leave.
Guides are written in WordPress and shown here unchanged. Browse by topic: hours & pay, PTO, shift schedules, payroll calendars or workforce.