How to Add 15 Minutes to Each Row Using Excel Formulas
Question details
The user needs to generate a continuous sequence of times in a spreadsheet by adding exactly 15 minutes to each subsequent row.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating a time sequence, schedule, or log in a spreadsheet starting from a specific time like midnight.
- Observed behavior
- Requires a reliable formula that automatically increments the time value by 15 minutes for every new row.
Ensure the column you are working with is formatted as 'Time' so that the generated formula values display correctly as hours and minutes.
Use the TIME Function to Add 15 Minutes
The TIME function is the most readable and straightforward method to add specific hours, minutes, or seconds to a given time.
The TIME function allows you to specify exact hours, minutes, and seconds to add to an existing time value, making your formulas very easy to read and adjust.
Select your starting cell (for example, B2) and type your initial time, such as 00:00:00.
Click the cell directly below it (B3) and enter the formula =B2+TIME(0,15,0).
Press Enter. You will see the time incremented by exactly 15 minutes (e.g., 00:15:00).
Select cell B3, click and hold the fill handle in the bottom-right corner of the cell, and drag it downward to fill the formula across all the rows you need.

Use Arithmetic Division to Increment Time
Since spreadsheet applications store dates and times as fractional values of a day, you can add 15 minutes using mathematical division.
Easily Generate Time Sequences with WPS Spreadsheet
WPS Spreadsheet fully supports Excel functions, including the TIME function and advanced date/time arithmetic, making it incredibly easy to create schedules and continuous time sequences.
- 1. Open WPS Spreadsheet: Launch WPS Office, create a new spreadsheet, and enter your starting time in the first cell.
- 2. Enter the formula: Type =B2+TIME(0,15,0) or your desired time increment formula in the cell directly below it.
- 3. Generate the sequence: Click and drag the fill handle downward to instantly generate your complete time sequence.

Frequently Asked Questions
Why does my time formula result show a standard decimal number instead of a time?
Spreadsheets store time as fractions of a 24-hour day. If your cell is formatted as 'General' or 'Number', it will display the underlying decimal value instead of a clock format. To fix this, select the cells, right-click, choose 'Format Cells', and select the 'Time' format.
How do I add hours instead of minutes using the TIME function?
The TIME function is formatted as TIME(hours, minutes, seconds). To add 2 hours instead of 15 minutes, you would change the parameters and use the formula =B2+TIME(2,0,0).
Can I subtract 15 minutes from a row in Excel?
Yes, you can easily subtract time by changing the plus sign to a minus sign in your formula. For example, use =B2-TIME(0,15,0) or =B2-15/(24*60) to subtract 15 minutes from the previous cell's time.




