1. ## 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>

2. ## 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>

Andrew C

3. ## Re: Time formulas (97)

See if the attached workbook does what you want.

4. ## 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

5. ## 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>

6. ## Re: Time formulas (97)

Thanks,
I now will get down to play....errr work and put this together.