-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Increase time by one minute intervals
jtakw
Well-known Member
- Joined
- Jun 29, 2014
- Messages
- 7,245
- Office Version
- 2016
- Platform
- Windows
Hi,
A couple of different ways to do it:
First method:
1. Enter a time in A1, and enter the same time adding 1 minute in A2
2. Select Both A1 and A2, Left click on the Fill Handle ( little square at lower right corner ) and drag down.
Another way using formula:
1. Enter a time in B1
2. Enter formula in B2, copy down.
A couple of different ways to do it:
First method:
1. Enter a time in A1, and enter the same time adding 1 minute in A2
2. Select Both A1 and A2, Left click on the Fill Handle ( little square at lower right corner ) and drag down.
Another way using formula:
1. Enter a time in B1
2. Enter formula in B2, copy down.
| Book1 | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | 8:00 AM | 8:00 AM | ||
| 2 | 8:01 AM | 8:01 AM | ||
| 3 | 8:02 AM | |||
| 4 | 8:03 AM | |||
| 5 | 8:04 AM | |||
| 6 | 8:05 AM | |||
| 7 | 8:06 AM | |||
| 8 | 8:07 AM | |||
| 9 | 8:08 AM | |||
| 10 | 8:09 AM | |||
| 11 | 8:10 AM | |||
| 12 | 8:11 AM | |||
| 13 | 8:12 AM | |||
Sheet454 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2 | =B1+1/1440 | |
Upvote
0
