Time formulas (97)

Topic

New Reply

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

Reply | Quote

Replies

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

=A1+TIME(0,10,0).

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

Andrew C

Reply | Quote

See if the attached workbook does what you want.

Reply | Quote

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

Reply | Quote

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:

=A1/1440
=TIME(0,A1,0)

Reply | Quote

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!!

Reply | Quote