Subtract a break when it fits the interval

Turn 11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM with a 0:30 break into 49:00.

What you'll make

In Excel: 11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM, 0:30 break becomes 49:00.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
1OR(C8<0,C8>B8-A8)Checks if the break is below zero or too long.FALSE
2"Review break"The message when the break doesn't fit.Not used for row 8
3B8-A8-C8Takes the start and the break from the end.49:00
4IF( … )Shows the message, or else the time left.49:00

Excel counts time in days. A break as long as the whole span is fine and gives 0:00.

=IF(OR(C8<0,C8>B8-A8),"Review break",B8-A8-C8)

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 times. Paste start and end dates with times, then breaks, into the green columns of the Template tab. The time after the break fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Type breaks as times like 0:30, not as 30. A plain 30 means 30 days.

Microsoft's help: IF function