Archive of Mr Excel Message Board
Back to Edit in Excel archive index
Back to archive home
Filling a seriesPosted 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.
Re: Filling a seriesPosted by Yogi Anand on February 05, 2002 9:16 PM
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!
ANAND Enterprises (broken link)
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.