Round timestamps down to a step
Turn 1/1/2027 7:15:30 AM into 7:10:00 AM on a 10-minute grid. Use 5, 10, 15, 30 or 60.
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 the minutes into part of a day. | 5 minutes |
| 3 | FLOOR.MATH( … ) | Rounds down to the step before. | 11/4/2026 2:30:00 PM |
Excel counts time in days, and a day has 1,440 minutes. A time already on a step stays the same.
=FLOOR.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 into the green column and the minute step next to each. 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
Use a step that fits a day evenly, like 5, 10, 15, 30 or 60.
Microsoft's help: FLOOR.MATH function
OTHER ROUTES YOU MIGHT LIKE

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 →
Add or subtract hours from a timestamp
11/4/2026 2:30:15 PM + 10 hours → 11/5/2026 12:30:15 AM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →