Round a timestamp up to the next step
Turn 11/4/2026 2:30:15 PM into 2:35:00 PM on a 5-minute schedule. The date can move too.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The date and time. | 11/4/2026 2:30:15 PM |
| 2 | B8/1440 | Turns 5 minutes into part of a day. | 0.00347 |
| 3 | CEILING.MATH( … ) | Rounds up to the next 5-minute mark. | 11/4/2026 2:35:00 PM |
Excel stores a day as 1, and a day has 1,440 minutes. Use a step that fits evenly into a day: 5, 10, 15, 30 or 60.
=CEILING.MATH(A8,B8/1440)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 dates and times. Paste dates with times and a step in minutes into the green columns of the Template tab. The rounded times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A time already on a mark stays the same. Close to midnight, rounding up moves the date to the next day.
Microsoft's help: CEILING.MATH function
OTHER ROUTES YOU MIGHT LIKE

Round timestamps down to a step
1/1/2027 7:15:30 AM, 10 minutes → 1/1/2027 7:10:00 AM
Get the template →
Add or subtract minutes from clock time
11:30 PM plus 90 minutes → 1:00 AM
Get the template →
Move a timestamp by minutes
12/31/2026 11:30:00 PM + 90 minutes → 1/1/2027 1:00:00 AM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →