Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Prescott, Arizona, USA
    Posts
    286
    Thanks
    0
    Thanked 1 Time in 1 Post

    Time formulas (97)

    I have searched the past post but could not find what I was looking for, so thanks in advance for your help with this formula.

    I have a certain time say, 7 PM
    Now I have three or four task that will take, say 10 min, 20 min and 45 min.

    I list a task and how many min that the task should take, say 10 min. Now I want a formula to calulate the 10 min and add it to the start time of 7 PM and display it. ( should be 7:10)
    Then I want to list the next task of 20 min and display it. (should be 7:30)
    Then the last task of 45 min and display it. (should be 8:15)

    Thank you, Mike <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Michael

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Time formulas (97)

    If you have a time in A1, you can use =A1+TIME(h,m,s) where h,m,s are the number of hours, minutes and seconds you want to add.

    To add 10 minutes to a time in A1 use <pre>=A1+TIME(0,10,0).</pre>

    If your answer is in B1 then =B1+TIME(0,20,0) will add 20 minutes to that value.

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time formulas (97)

    See if the attached workbook does what you want.
    Attached Files Attached Files
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Prescott, Arizona, USA
    Posts
    286
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Time formulas (97)

    THANKS Andrew and Legare, your posts got me going in the right direction!

    Is there a way for easy entry of the minutes. Since this will be a ongoing changing schedule, is there a way to just enter the a number to represent the number of minutes that could be read by the formula?

    (enter 15 in a cell and use that number to represent 15 min in the formula?)

    Thanks again!
    Mike
    Michael

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time formulas (97)

    You can put 15 into a cell as a number (not a time value), and then when you need to use it as a time value you can convert it to a time value. There are a couple of ways to do this. If cell A1 contains the number 15, then the following will convert it to a time value:

    <pre>=A1/1440
    =TIME(0,A1,0)
    </pre>

    Legare Coleman

  6. #6
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Prescott, Arizona, USA
    Posts
    286
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Time formulas (97)

    Thanks,
    I now will get down to play....errr work and put this together.
    Thanks again for your help.
    Woody's lounge is the greatest!!
    <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
    Michael

Posting Permissions

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