Convert decimal minutes to a duration
Turn 2970 minutes into the duration 49:30, even past 24 hours.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | A8 | The number of minutes, like 2970. | 2970 |
| 2 | /1440 | Divides by 1440, the minutes in one day. | 49:30 |
Excel counts time in days. The result shows hours and minutes, so 2970 shows as 49:30, not 1:30.
=A8/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 minutes. Paste numbers of minutes into the green column 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. Use [h]:mm:ss when seconds matter.
Microsoft's help: TIME function
OTHER ROUTES YOU MIGHT LIKE

Convert a duration to total minutes
49:30 → 2970 minutes
Get the template →
Convert decimal seconds to a duration
178215 seconds → 49:30:15
Get the template →
Convert a duration to total seconds
49:30:15 → 178215 seconds
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →