CODEWITHSUNDEEP
exceldatetimeseries
MGs
MGs

Reputation: 290

Excel Create Date and Hour Series

I would like to create in Excel in a column, e.g A, date and time series with a certain time step. For example:

14.10.2016 00:00:00
14.10.2016 04:00:00
14.10.2016 08:00:00

and so on.....

Then just drag the cell down and go as further in date as I want.

Any idea? Thank you very much in advance!

Upvotes: 1

Views: 1912

Answers (1)

codtex
codtex

Reputation: 6548

Fill the first two cells with the initial value and the step value for example:

A1 = 14.10.2016 00:00:00

A2 = 14.10.2016 04:00:00

Now highlight both cells and drag down from the bottom right corner of the second cell

Upvotes: 2

Related Questions