Intermittent FMLA Tracking Spreadsheet: How to Log Hours Without Losing Leave

Your Employer Controls the Clock — Unless You Track It Yourself

When you take FMLA leave in a single block, the math is simple: 12 weeks off, 12 weeks charged. Intermittent FMLA is different. Every doctor's appointment, every medical transport, every crisis phone call gets deducted from your entitlement in small increments — and most employees never independently verify whether their employer is calculating those increments correctly.

If you work a standard 40-hour week, your total FMLA entitlement is 480 hours (40 hours x 12 weeks). Every absence gets subtracted from that pool. The problem is that many employers round up, charge full hours for partial absences, or use increments larger than their payroll system requires. Without your own tracking, you have no way to catch it.

How Intermittent FMLA Increments Actually Work

The Department of Labor's rule is specific: your employer must calculate intermittent leave using the shortest increment their payroll system tracks for any type of absence, as long as that increment is one hour or less.

If your company's payroll system tracks absences in 15-minute increments for vacation or sick time, they must use 15-minute increments for FMLA too. They cannot force you to burn a full hour of FMLA for a 20-minute absence.

If the payroll system tracks in increments larger than one hour (which is unusual), the employer must still allow FMLA leave in increments of one hour or less.

Here's a practical example:

• You leave work 45 minutes early for your parent's dialysis transport
• Your company tracks PTO in 15-minute blocks
• The FMLA charge should be 0.75 hours (three 15-minute increments), not a full hour
• Over a year of weekly appointments, that rounding error could eat 13 extra hours — more than a full workday of protected leave

What to Track in Your Spreadsheet

Keep a running log with these columns:

Date — when the absence occurred

FMLA reason — brief description (e.g., "parent's oncology appointment," "dialysis transport," "home care coordination")

Time departed / Time returned — exact clock times, not rounded estimates

Actual time missed — calculated to the minute

FMLA charged — what your employer reports on your leave balance, using their increment system

Running balance — your total remaining FMLA hours based on your tracking vs. what your employer shows

Compare your running balance against whatever your employer or their third-party leave administrator reports monthly. Discrepancies surface quickly when you're tracking at the 15-minute level and they're rounding to the hour.

The Rolling 12-Month Calculation

Most employers use one of four methods to calculate the 12-month FMLA period, and the method they choose dramatically affects when your leave entitlement resets:

Calendar year: January 1 through December 31. Simple but allows employees to take 24 consecutive weeks if they start in late December and continue into January.

Fixed 12-month period: Any consistent 12-month block (fiscal year, anniversary date, etc.).

Rolling forward: Measured from the first date you use FMLA leave. Twelve months from that first absence, the entire entitlement resets.

Rolling backward (most common): Each time you take FMLA leave, the employer looks back 12 months from that date. Whatever you've used in the prior 12 months gets subtracted from your 480-hour entitlement. This means leave hours gradually "roll off" as they age past 12 months.

The rolling backward method is the most complex to track because your available balance changes every day. On any given date, your remaining FMLA time equals 480 hours minus however many FMLA hours you used in the preceding 365 days.

Your employer must inform you which method they use — it should be stated in their FMLA policy or on the WH-381 eligibility notice. If they haven't told you, ask HR in writing.

When Discrepancies Get Serious

If your tracking shows a meaningful gap between what you've actually used and what your employer has charged, you have grounds to dispute. Common employer errors include:

• Charging full days when only partial days were used
• Using larger increments for FMLA than for other absence types
• Double-counting absences (marking both FMLA and sick time for the same hours)
• Miscalculating the rolling 12-month window

Raise discrepancies in writing with HR. Reference the specific DOL regulation (29 CFR § 825.205) requiring minimum increment tracking. If the employer doesn't correct the error, you can file a complaint with the Department of Labor's Wage and Hour Division — there's no filing fee.

The Working While Caregiving toolkit includes a pre-built intermittent leave tracker with auto-calculating balances for all four 12-month calculation methods, plus a template dispute letter for HR.