Fill range with incremental time in Excel

For example, I want to create a table to capture "Room temperature" at 6 min intervals for about an hour starting from 9 AM.

To do it in Excel, here is the answer:

a) Enter the formula =AJ2+TIME(0,6,0) in AJ3 where AJ2 contains the start time (9 AM).

Time(0,6,0) adds 6 minutes to start time (AJ2). First parameter corresponds to hours, second parameter corresponds to minutes and the third corresponds to seconds.

excel fill range with incremental time

b) Copy the formula in AJ3 in the cells below as required.

excel fill range with incremental time


You can find similar Excel Questions and Answer hereunder

1) How can I remove hyperlinks from a range of cells?

2) How can I find the sum of records that meet a given condition in my raw data table?

3) How can I find the count of records that meet multiple conditions in my raw data table?

4) Can I determine the number of times a character appears in a cell using formula?

5) what are the main range object and what can the range objects do in VBA

6) Here some more advanced range objects and what you can do with the range object in VBA

7) How can I clear all formats (formats alone not data) from a range of cells?

8) Sumifs with date range as criteria in Excel

9) Is there a way I can average a range of numbers even if there is an error value in range?

10) How can I quickly remove all blank cells in a data range?


Here the previous and next chapter