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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The duration, like 49:30:15. | 49:30:15 |
| 2 | "[h]:mm:ss" | The pattern: total hours, then minutes and seconds. | "[h]:mm:ss" |
| 3 | TEXT( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own durations. Paste durations into the green column of the Template tab. The labels fill in by themselves.
- 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
OTHER ROUTES YOU MIGHT LIKE

Show a negative duration as text
A negative 90-minute difference → -1:30
Get the template →
Show a letter time with AM or PM
14:30 → 2:30 PM, 00:00 → 12:00 AM, blank stays blank
Get the template →
Show a 24-hour time including seconds
2:30:15 PM → 14:30:15
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →