27 ways to work the numbers, step by step

Convert shift clock times into 24-hour military time, subtract start time from end time, deduct unpaid meal breaks, and divide remaining minutes by 60 to convert into decimal hours.

1. Convert to 24-Hour Format: Add 12 to PM times (e.g., 5:15 PM = 17:15).
2. Subtract Start Time from End Time: Find gross shift duration.
3. Deduct Unpaid Lunch Break: Subtract break minutes (e.g., 30 mins).
4. Convert Minutes to Decimal: Divide minutes by 60.

Multiply your hourly wage by weekly hours worked, then multiply by 52 weeks (standard full-time work year = 2,080 hours).

1. Identify Base Hourly Rate: E.g., $25.00/hour.
2. Identify Weekly Hours: Full-time standard is 40 hours/week.
3. Multiply Rate × Hours × 52 Weeks: Calculate gross yearly wage.

Divide annual gross salary by the total full-time annual working hours (2,080 hours for a 40-hour workweek across 52 weeks).

1. Determine Annual Gross Income: E.g., $60,000/year.
2. Determine Total Annual Hours: 40 hours/week × 52 weeks = 2,080 hours.
3. Divide Salary by Total Hours: Calculate exact hourly base rate.

Subtract birth date from target evaluation date across Year, Month, and Day columns, borrowing days or months as needed.

1. Set Up Columns: Target Date (YYYY/MM/DD) above Birth Date (YYYY/MM/DD).
2. Subtract Days: If target day < birth day, borrow preceding month's total days.
3. Subtract Months: If target month < birth month, borrow 12 months from target year.
4. Subtract Years: Subtract birth year from adjusted target year.

Convert both dates into absolute epoch serial days and find the mathematical difference between them.

1. Identify Start Date and End Date.
2. Count Elapsed Full Days: Account for differing month lengths (28, 30, 31 days).
3. Adjust for Leap Years: Add +1 day for every February 29th crossed.

Eastern Standard Time (EST, UTC−5) is 3 hours ahead of Pacific Standard Time (PST, UTC−8). Add 3 hours to PST to obtain EST.

1. Identify PST Time: E.g., 10:00 AM PST.
2. Add 3 Hours: 10:00 AM + 3 hours = 1:00 PM EST.
3. Adjust Calendar Day: If addition crosses midnight, advance date by +1 day.

India Standard Time (IST) operates at a fixed offset of UTC+5:30. Add 5 hours and 30 minutes to UTC time.

1. Identify UTC Time: E.g., 08:00 UTC.
2. Add 5 Hours: 08:00 + 5 hours = 13:00 (1:00 PM).
3. Add 30 Minutes: 13:00 + 30 mins = 13:30 (1:30 PM IST).

Under US federal FLSA rules, non-exempt employees receive 1.5 times their regular hourly rate for hours worked beyond 40 in a workweek.

1. Determine Base Hourly Wage: E.g., $20.00/hour.
2. Calculate Overtime Rate: Multiply base rate by 1.5 ($20 × 1.5 = $30.00/hr).
3. Calculate Overtime Hours: Total weekly hours − 40 hours.
4. Multiply Overtime Rate × Overtime Hours.

Use Excel's built-in NETWORKDAYS formula to calculate net working weekdays (Monday–Friday) while excluding holidays.

1. Enter Start Date in Cell A2 and End Date in Cell B2.
2. List Holiday Dates in Cells E2:E10 (Optional).
3. Enter Formula: =NETWORKDAYS(A2, B2, E2:E10).

Align wake-up times with natural 90-minute sleep cycles plus 15 minutes to fall asleep to avoid sleep inertia.

1. Identify Fixed Wake-Up Alarm: E.g., 6:30 AM.
2. Subtract 90-Minute Blocks (Sleep Cycles): 5 cycles = 7.5 hours; 6 cycles = 9 hours.
3. Subtract 15 Minutes (Sleep Latency): Adjust for time needed to fall asleep.

Divide total clock minutes by 60 to convert standard sexagesimal minutes into base-10 decimals required for wage calculations.

1. Isolate Minutes Portion of Time: E.g., 7 hours 45 minutes.
2. Divide Minutes by 60: 45 / 60 = 0.75.
3. Combine Whole Hours with Decimal: 7 + 0.75 = 7.75 decimal hours.

Convert break duration into decimal format or subtract break minutes directly from total daily shift elapsed time.

1. Calculate Gross Elapsed Shift Duration: E.g., 9:00 AM to 5:30 PM = 8.5 hours (8 hrs 30 mins).
2. Convert Lunch Break to Decimals: 30 minutes / 60 = 0.50 hours.
3. Subtract Lunch Break Decimal from Gross Hours: 8.50 − 0.50 = 8.00 net hours.

Multiply regular hours by hourly rate, then add overtime hours multiplied by the premium overtime rate.

1. Calculate Regular Earnings: Regular Hours (up to 40) × Base Pay Rate.
2. Calculate Overtime Earnings: Overtime Hours (>40) × (Base Rate × 1.5).
3. Sum Regular + Overtime Earnings.

When an overnight shift crosses midnight, add 24 hours to the clock-out end time before subtracting the clock-in start time.

1. Identify Start Time and End Time: E.g., Start 10:00 PM (22:00), End 6:00 AM (06:00).
2. Add 24 Hours to End Time: 06:00 + 24 = 30:00.
3. Subtract Start Time: 30:00 − 22:00 = 8.00 hours.
4. Deduct Unpaid Breaks.

Multiply base hourly pay rate by 2.0 for hours qualifying under state laws (e.g., California work past 12 hours/day) or union contracts.

1. Determine Base Hourly Wage: E.g., $22.00/hour.
2. Calculate Double Time Rate: $22.00 × 2.0 = $44.00/hour.
3. Multiply Double Time Rate by Double Time Hours Worked.

Sum minutes and hours independently. Convert every 60 accumulated minutes into +1 hour and add it to the hours column.

1. Sum Minutes Column: E.g., 45 mins + 35 mins = 80 mins.
2. Convert Minutes to Hours + Remainder: 80 mins = 1 hr 20 mins.
3. Sum Hours Column & Add Carryover Hour: 6 hrs + 5 hrs + 1 carried hr = 12 hrs.
4. Final Result: 12 hours 20 minutes.

Subtract mandatory taxes (Federal Income Tax, State Income Tax, FICA Social Security 6.2%, Medicare 1.45%) and voluntary benefit deductions from gross pay.

1. Determine Gross Wages for Pay Period.
2. Calculate FICA Tax (7.65%): Gross Pay × 0.0765.
3. Deduct Income Taxes (Federal + State based on Form W-4).
4. Deduct Voluntary Benefits (Health Insurance, 401k).

Count forward chronologically from the starting date, adjusting for the specific days in preceding months (28, 30, or 31) and leap years.

1. Identify Start Date and Number of Days to Add.
2. Add Days sequentially across calendar months.
3. Advance Year if calculation crosses December 31st.

Multiply base hourly wage directly by 40 hours for a single workweek calculation.

1. Determine Hourly Pay Rate: E.g., $22.50/hour.
2. Multiply Hourly Rate × 40 Hours.

Input your birth month, day, and year into a Day of the Week tool or compute manually using Zeller's Congruence algorithm.

1. Identify Date of Birth: E.g., July 4, 1776.
2. Run Day of Week Algorithm / Tool.
3. Output Day Name: E.g., Thursday.

Subtract DOB from Test Date without rounding, borrowing the preceding month's actual days, or 12 months from years, when needed.

1. Align Dates: Test Date (YYYY/MM/DD) over Birth Date (YYYY/MM/DD).
2. Subtract Days column first (borrow the preceding month's days if needed).
3. Subtract Months column second (borrow 12 months if needed).
4. Subtract Years column.

Under FLSA quarter-hour rounding rules, clock punches from 1–7 minutes round down, while 8–14 minutes round up to the nearest 15-minute mark.

1. Check Punch Minute Mark: E.g., 8:07 AM vs 8:08 AM.
2. Apply 1–7 Min Rule: 8:07 AM rounds down to 8:00 AM.
3. Apply 8–14 Min Rule: 8:08 AM rounds up to 8:15 AM.

Calculate elapsed hours for the Morning Shift and Evening Shift independently, then sum the two net totals together.

1. Calculate Shift 1 Hours: E.g., 8:00 AM to 12:00 PM = 4.0 hours.
2. Calculate Shift 2 Hours: E.g., 4:00 PM to 8:00 PM = 4.0 hours.
3. Sum Shift 1 + Shift 2: 4.0 + 4.0 = 8.0 total daily hours.

Eastern Standard Time (EST, UTC−5) is 1 hour ahead of Central Standard Time (CST, UTC−6). Add 1 hour to CST to find EST.

1. Identify Central Time (CST): E.g., 2:00 PM CST.
2. Add 1 Hour: 2:00 PM + 1 hour = 3:00 PM EST.

Calculate total lifetime days lived from date of birth to today, then multiply total days by 24 hours.

1. Find Total Days Lived: E.g., 10,000 days.
2. Multiply Total Days × 24 Hours.

Turn an annual PTO allotment into what you earn each paycheck and each hour worked, then track your available balance after time off used.

1. Convert annual PTO to hours: Days × hours per workday (15 days × 8 = 120 hours).
2. Divide by pay periods per year: 120 ÷ 26 bi-weekly = 4.62 hours accrued per paycheck.
3. Multiply by periods completed: 4.62 × 10 paychecks = 46.2 hours accrued so far.
4. Subtract hours used: Starting balance + accrued − used = available balance.

Find exactly how much time remains until a future date — in days and down to the second — including how many of those are business days.

1. Identify the target date (and time, if it matters).
2. Subtract now from the target: target − current moment = time remaining.
3. Convert to units: total seconds ÷ 86,400 = days; the remainder gives hours, minutes, and seconds.
4. Count business days: include only Monday–Friday between the two dates.