Build a duration from hours and minutes
Turn 49 hours and 30 minutes into the duration 49:30, even past 24 hours.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/24 | The hours, divided by 24 hours in a day. | 49:00 |
| 2 | +B8/1440 | Adds the minutes. A day has 1,440 minutes. | 49:30 |
Excel counts time in days. The result column shows hours and minutes, so 49:30 stays 49:30.
=A8/24+B8/1440How 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 hours and minutes. Paste whole hours and minutes into the green columns of the Template tab. The durations fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
If you copy a duration elsewhere, give that cell the format [h]:mm. Otherwise 49:30 shows as 1:30.
Microsoft's help: TIME function
OTHER ROUTES YOU MIGHT LIKE

Calculate hours between timestamps
11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 49.5 hours
Get the template →
Count minutes between timestamps
11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 2970 minutes
Get the template →
Count seconds between timestamps
11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 178200 seconds
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →