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.

What you'll make

In Excel: 8 hours, Delta -0.5 becomes 7.5 hours.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1C8Reads the correction mode for this row."Delta"
2"Delta",A8+B8Delta: adds the correction to the original hours.7.5
3"Replacement",B8Replacement: uses the correction instead.Not used for row 8
4SWITCH( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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