Add or replace hours by correction mode
A Delta of -0.5 turns 8 hours into 7.5. A Replacement of 7.75 gives 7.75.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | C8 | Reads the correction mode for this row. | "Delta" |
| 2 | "Delta",A8+B8 | Delta: adds the correction to the original hours. | 7.5 |
| 3 | "Replacement",B8 | Replacement: uses the correction instead. | Not used for row 8 |
| 4 | SWITCH( … ) | Uses the part that matches the mode. | 7.5 |
Read it left to right. Any other mode says Review correction amount mode.
=SWITCH(C8,"Delta",A8+B8,"Replacement",B8,"Review correction amount mode")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 corrections. Paste the original hours, the correction and its mode (Delta or Replacement) into the green columns of the Template tab. The corrected hours fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Take the mode from the correction record itself; never guess it from the size of the number.
Microsoft's help: SWITCH function
OTHER ROUTES YOU MIGHT LIKE

Add a correction unless the total has it
38.5 + 0.75, not yet included → 39.25 hours
Get the template →
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 →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →