MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Filling a series


Posted by Zack Dixon on February 05, 2002 2:10 PM

I'm trying to fill a series every 144 cells instead of one. Column A is time, every 10mins using a 24-hour clock. So every 24hrs is 144 cells. I have these times but no dates, I have the starting date. It would be simple enough to cut and paste, but I have around 25000 entries and I need someway of getting the dates in there.


Posted by Yogi Anand on February 05, 2002 9:16 PM

Hi Zack:
If I understand it correctly, you want to create a series of numbers starting on a given date at 0:00 hour, with a step value of 10 minutes over a period of some 6 months (that will give you 25000 and then some values. You can do this all in one step by creating a series. Assuming you want to create a series starting with Feb-7-2002 at 0:00 hour, every 10 minutes until Ju-31-2002 0:00.
this is what you do: Click on a cell starting below which you want to start the series in a column, key in the starting Date like this 2/7/2002 0:00

EDIT|FILL|SERIES|Series in: columns; Type: Date; Date Unit: Day; Step value: 0:10; Stop value 7/31/2002 0:00 ... then OK Bingo!

HTH

Yogi Anand
ANAND Enterprises (broken link)