Count the time blocks a duration needs
A 36:10 duration needs 145 blocks of 15 minutes. Any part of a block counts as a whole one.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The duration, like 49:30. | 49:30 |
| 2 | *1440/B8 | Turns it into minutes, then counts 15-minute blocks. | 198 |
| 3 | ROUNDUP( … ,0) | Rounds any part block up to a whole one. | 198 |
A day has 1,440 minutes. 36:10 is 2,170 minutes, or 144.67 blocks of 15, so it needs 145.
=ROUNDUP(A8*1440/B8,0)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 and a block length in minutes into the green columns of the Template tab. The blocks fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type the block length as plain minutes, like 15, not as a time like 0:15.
Microsoft's help: ROUNDUP function
OTHER ROUTES YOU MIGHT LIKE

Find minutes left after whole blocks
49:30 in 60-minute blocks → 30 minutes left
Get the template →
Write a duration as days, hours, minutes
49:30 → 2d 1h 30m
Get the template →
Write a duration as minutes and seconds
49:30:15 → 2970m 15s
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →