×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Data fill with time/date.

Data fill with time/date.

Data fill with time/date.

(OP)
I want to generate a series of times and dates, incremented hourly. Say I put  in the first cell, then drag teh doohicky down. It increments daily. If I put "5/1/2007 15:00" in the second cell, it alternates
 
  5/1/2007 15:00
  5/1/2007 14:00
  5/1/2007 15:00  
  5/1/2007 14:00   
  ...

How do I get it to fill like this:

  5/1/2007 14:00
  5/1/2007 15:00
  5/1/2007 16:00?

     "...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928

"I'm searching for the questions, so my answers will make sense." - Stephen Brust

RE: Data fill with time/date.

When I do it I get:

5/1/07 15:00
5/1/07 16:00
5/1/07 17:00
5/1/07 18:00
5/1/07 19:00
5/1/07 20:00
5/1/07 21:00
5/1/07 22:00
5/1/07 23:00

I think you're doing something wrong but I don't know wha.  Plus your example has dates decremented, not incremented

RE: Data fill with time/date.

Ok I think it's how you format it.  Put the 5/1/07 15:00
in the first cell and copy it to the second, then change the 15:00 to 16:00 in the second cell and it should work

RE: Data fill with time/date.

Note that there will be a slight error on the order of 3.8 ppm per increment, due to the binary representation error of 1 hr being 1/24th of a day, which is the timestamp representation used in Excel.

IF you need that to be more accurate, then the best thing to do is to use an index that cycles every 24 counts and divide that by 24 and add to the whole day count.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies


RE: Data fill with time/date.

You are probably getting odd results because the dates are entered as text and not dates.  As soon as the date is entered in the cell using the date format you will be able to increment by 1 hour by dragging.  You can also use the Edit:Fill:Series menu item.  Choose 0.0416666666666667 as your increment

RE: Data fill with time/date.

Hi ACtrafficengr:

Foloowing is a solution using EDIT|Fill|Series ...

CODE

5/1/2007 14:00
5/1/2007 15:00
5/1/2007 16:00
5/1/2007 17:00
5/1/2007 18:00
5/1/2007 19:00
5/1/2007 20:00
5/1/2007 21:00
5/1/2007 22:00
5/1/2007 23:00
5/2/2007 0:00
I did it using the following steps ...

CODE

1. I keyd-in 5/1/2007 14:00 in cell A1
2. I selected column A
3. I invoked EDIT|Fill|Series ...
   a) then in Series_in box I selected the option Columns
   b) in the Type box, I selected Date
   c) in Step_size I keyd-in 0 1/24
   d) in Stop_value I keyd-in 5/2/2007
   e) in the Date_unit box I selected Day
4. Then I clicked OK
and got the result as shown above.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources