Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Atlanta, Georgia, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic summing (sometimes) (2000 and XP)

    I've got a simple spreadsheet that allows me to track my time throughout the day. I enter a project description, start and end times, and then determine the time worked. It looks like this:
    <pre> Task | Start | End | Time Worked
    Post on Lounge | 13:30 | 13:45 | 0:25
    </pre>


    Sometimes, if the next row is empty, I can type the task, start, and end time, and Excel will fill in the time worked "automatically." Sometimes, though, it doesn't and I have to copy the Time Worked formula and paste it. This is not a big deal, but I'd like to understand why it does it sometimes and not others. It seems almost like Word's Autocorrect, but I can't find any options like that on the menus.

    Thanks!
    Bob
    Writing Consultant / Word Template Designer
    Words Connect

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Automatic summing (sometimes) (2000 and XP)


  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Atlanta, Georgia, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic summing (sometimes) (2000 and XP)

    Thanks Hans! I had been testing along those lines, but I guess I was using one row too few. Once I tested with five rows of similarly formatted data, the auto extend worked.

    Bob
    Writing Consultant / Word Template Designer
    Words Connect

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •