Calculate time remaining to a deadline

See how much time is left before each deadline. A passed deadline shows 0:00:00.

What you'll make

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

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
10The lowest result allowed: zero.0
2B8-A8Takes the from time away from the deadline.49:30:00
3MAX( … )Shows the bigger one, so it never goes below zero.49:30:00

Excel counts time in days. The result shows whole days as hours, like 49:30:00.

=MAX(0,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 from dates with times, then deadlines, into the green columns of the Template tab. The time remaining fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Type both times in the same time zone. The formula doesn't convert zones.

Microsoft's help: MAX function