Write elapsed hours with seconds

Turn the duration 49:30:15 into the text 49:30:15, so it never resets to 1:30:15.

What you'll make

In Excel: 49:30:15 becomes text 49:30:15, not 1:30:15.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The duration, like 49:30:15.49:30:15
2"[h]:mm:ss"The pattern: total hours, then minutes and seconds."[h]:mm:ss"
3TEXT( … )Writes the duration in that pattern as text."49:30:15"

Read it left to right. The square brackets keep every hour, so 49 hours never turns into 1.

=TEXT(A8,"[h]:mm:ss")

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 durations. Paste durations into the green column of the Template tab. The labels fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

The labels are text, so they can't be added up. Keep the original durations for any totals.

Microsoft's help: TEXT function