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.
b) Copy the formula in AJ3 in the cells below as required.