Excel/word formula help dealing with time.

Discussion in 'OT Technology' started by zanyspy_dude, Sep 13, 2007.

  1. zanyspy_dude

    zanyspy_dude King of teh n00bz

    Joined:
    Aug 29, 2002
    Messages:
    4,473
    Likes Received:
    0
    Location:
    Indianapolis, IN
    I need to know how to increment time in a word/excel formula

    I have 3 columns. First is the activity, second is the time allotted, the third is the time of the class the activity needs to end.

    How do i start with 3:35 pm and increment the value from the second column to get the third column value that will update as i change the time allotted?

    edit:added pic

    [​IMG]
     
    Last edited: Sep 13, 2007
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Now that's how you ask a question:

    Stick the start time somewhere (let's say $D$1).

    Then change C2 to:

    =TIME(HOUR($D$1),MINUTE($D$1)+B2,SECOND($D$1))

    And C3 to:

    =TIME(HOUR(C2),MINUTE(C2)+B3,SECOND(C2))

    Pull the formula down to the rest of the column.
     
  3. zanyspy_dude

    zanyspy_dude King of teh n00bz

    Joined:
    Aug 29, 2002
    Messages:
    4,473
    Likes Received:
    0
    Location:
    Indianapolis, IN
    any easy way to do this in word? (i don't mind copying over from excel, but word is where i'm using it) I kinda feel like you can just copy excel in and the formulas still work, but i'll have to test that...
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    You should just embed the excel document
     

Share This Page