Add or subtract minutes from clock time
Turn 11:30 PM plus 90 minutes into 1:00 AM. The time wraps at midnight.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | A8 | The clock time. | 2:30 PM |
| 2 | +B8/1440 | Adds the minutes. A day has 1,440 minutes. | 3:15 PM |
| 3 | 1 | One whole day. | 1 |
| 4 | MOD( … ) | Drops whole days, so the time wraps at midnight. | 3:15 PM |
Excel stores a day as 1. A minus sign before the minutes goes back in time.
=MOD(A8+B8/1440,1)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 times. Paste clock times and minutes into the green columns of the Template tab. The new times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Whole days are dropped on purpose, so 1,500 minutes moves the clock 1 hour. Use full dates with times to track days.
Microsoft's help: MOD function
OTHER ROUTES YOU MIGHT LIKE

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 →
Move a timestamp by seconds
12/31/2026 11:30:00 PM + 1800 seconds → 1/1/2027 12:00:00 AM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →