Add a correction unless the total has it
Add 0.75 hours to a 38.5-hour total only when the total doesn't already include it.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | NOT(ISLOGICAL(C8)) | Checks that column C isn't TRUE or FALSE. | FALSE |
| 2 | "Review totals inclusion basis" | The message when column C isn't TRUE or FALSE. | Not used for row 8 |
| 3 | IF(C8,A8,A8+B8) | TRUE keeps the total; FALSE adds the correction. | 39.25 |
| 4 | IF( … ) | Shows part 2 if part 1 is TRUE, else part 3. | 39.25 |
Column C must hold TRUE or FALSE, not yes or no. Corrections can be negative.
=IF(NOT(ISLOGICAL(C8)),"Review totals inclusion basis",IF(C8,A8,A8+B8))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own hours. Paste the source total, the posted correction and TRUE or FALSE into the green columns of the Template tab. The report total fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check in the source report whether its total already includes the correction. Marking it wrong counts it twice or not at all.
Microsoft's help: IS functions
OTHER ROUTES YOU MIGHT LIKE

Calculate hours from checked punches
IN 11/4/2026 2:30:15 PM, OUT 10:45:15 PM → 8.25 hours
Get the template →
Prevent a repeated meal deduction
8.5 hours, 0.5 meal, deduction requested → 8 hours
Get the template →
Add or replace hours by correction mode
8 hours, Delta -0.5 → 7.5 hours
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →