Function Problems

How to Add 15 Minutes to Each Row Using Excel Formulas

Elise WilliamsElise Williams Oct 29, 2026 870 views

Question details

The user needs to generate a continuous sequence of times in a spreadsheet by adding exactly 15 minutes to each subsequent row.

How to Add 15 Minutes to Each Row Using Excel Formulas
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.
Before you start

Ensure the column you are working with is formatted as 'Time' so that the generated formula values display correctly as hours and minutes.

Solution 1Recommended

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.

1
Enter the starting time

Select your starting cell (for example, B2) and type your initial time, such as 00:00:00.

2
Input the TIME formula

Click the cell directly below it (B3) and enter the formula =B2+TIME(0,15,0).

3
Apply the formula

Press Enter. You will see the time incremented by exactly 15 minutes (e.g., 00:15:00).

4
Fill the sequence down

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 the TIME Function to Add 15 Minutes
Time Formatting: If the result appears as a decimal number instead of a time, right-click the selected cells, choose 'Format Cells', and select the 'Time' format.

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. 1. Open WPS Spreadsheet: Launch WPS Office, create a new spreadsheet, and enter your starting time in the first cell.
  2. 2. Enter the formula: Type =B2+TIME(0,15,0) or your desired time increment formula in the cell directly below it.
  3. 3. Generate the sequence: Click and drag the fill handle downward to instantly generate your complete time sequence.
Fully compatible with Microsoft Excel formulas, functions, and time formatting.Lightweight and completely free to use for daily spreadsheet tasks.Intuitive drag-and-fill handles to generate long time sequences in seconds.
microsoft office alternative - wps office

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.