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

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | OR(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 |
| 3 | B8-A8-C8 | Takes the start and the break from the end. | 49:00 |
| 4 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Count the time blocks a duration needs
36:10 in 15-minute blocks → 145 blocks
Get the template →
Write a duration as days, hours, minutes
49:30 → 2d 1h 30m
Get the template →
Write a duration as minutes and seconds
49:30:15 → 2970m 15s
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →