Calculate progress through an interval

Turn a start, an end and a time into how far along it is, from 0% to 100%.

What you'll make

In Excel: 11/4/2026 14:30 to 11/6/2026 16:00, at 11/5/2026 15:15 becomes 50%.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8<=A8Checks if the end is at or before the start.FALSE
2"Review interval"The message shown when the end isn't after the start.Not used for row 8
3(C8-A8)/(B8-A8)Time since the start, as a share of the interval.50%
4MAX(0,MIN(1, … ))Keeps it between 0% and 100%.50%
5IF( … )Shows part 2 when part 1 is TRUE, otherwise the progress.50%

Read it left to right. MAX and MIN wrap part 3, and IF wraps everything, so it works last.

=IF(B8<=A8,"Review interval",MAX(0,MIN(1,(C8-A8)/(B8-A8))))

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, end and the time to check into the green columns of the Template tab. The progress fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use one time zone for all three times. A time before the start shows 0%, and after the end 100%.

Microsoft's help: IF function