Picking up after closing triggers a late fee — usually per minute or per started block, after a short grace. Minutes late times the rate (rounded to blocks) gives the charge.
The example
22 min late, 0 grace, $1/min.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 22 × $1 | — |
| 3 | Late fee | → $22 |
The formula
The formula:
How it works
How it works:
- Compute minutes late = pickup time − close time.
- Subtract any grace; MAX(…, 0) floors it.
- Multiply by the per-minute rate, or round to per-block with ROUNDUP.
- A per-15-minute fee:
ROUNDUP(minutes/15, 0) × block_fee.
Per-block fees round up to discourage chronic lateness. A “$15 per 15 minutes” policy charges a full block the moment you’re one minute over — ROUNDUP(minutes/15, 0) × 15 — which is intentional: it makes lateness costly and predictable. Per-minute fees are gentler. Pick the structure that fits your center’s culture, and state the grace period and rate in the enrollment agreement.
Try it: interactive demo
Minutes late, grace, per-minute rate.
Variations
Per-15-minute block
Round up blocks:
Minutes from times
Pickup − close:
Flat after grace
One flat fee:
Pitfalls & errors
Floor at zero. On-time pickup is $0 — MAX.
1440 minutes/day. Times are day fractions — ×1440 for minutes.
State the policy. Grace and rate belong in the enrollment agreement.
Practice workbook
Frequently asked questions
How do I calculate a late pickup fee in Excel?
How do I do per-15-minute blocks?
How do I get minutes late from clock times?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class