fill range with incremental time in Excel

Q19. In Excel, how can I fill a range of cells with incremental times?

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 excel fill range with incremental time


You can find similar Excel Questions and Answer hereunder

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

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

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

4) How can I add a Prefix to a set of numbers in a range?

5) Is there a way to easily shade alternate rows in a data range for improving readability?

6) How can I fill a series of data automatically?

7) How to do date and time zone conversion in excel in Excel

8) How do I get the 2nd highest number in a range of numbers?

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

10) Sumifs with date range as criteria in Excel

11) How can I set up a dynamic named range that expands automatically when new items are added to the list?

12) I have a complex voluminous workbook with lot of formulas. Every time I make an update, the processing is slow. Any workarounds available?

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

14) How do I find the median salary of employees with the same skillset in my Organization?

15) How can I get an estimate of Standard Deviation of a sample dataset?