Using a formula to add time

[Teresa]

1. I am using EXCEL.
2. I am trying to plan my day.
3. I am using a formula to add a certain number of minutes to a
certain military time. Usually, I just add the time the last task
is supposed to finish (ie 1200) to the number of minutes the next task
will take, ie 30. And I get 1230.
4. But, this does not work all the time because the clock starts
over at 59. If, for example, the last task finished at 1230, and the
next task will take 30 minutes, then my calculation gives me 1260 but
there is no such time is 1260. I then manually add 40 to this
formula, which gives me the correct time of 1300. But this takes a
lot of time.
5. Is there a formula I can use to do this automatically? Or, is
there a way to do my planning with actual times rather than just
numbers that represent miliary times so that if I added 30 minutes to
12:30 I would get 1:00?

Thank you very much for your help!
Teresa

 

[Bernard Rey]

Teresa wrote :

1. I am using EXCEL.
2. I am trying to plan my day.
3. I am using a formula to add a certain number of minutes to a
certain military time. Usually, I just add the time the last task
is supposed to finish (ie 1200) to the number of minutes the next task
will take, ie 30. And I get 1230.
4. But, this does not work all the time because the clock starts
over at 59. If, for example, the last task finished at 1230, and the
next task will take 30 minutes, then my calculation gives me 1260 but
there is no such time is 1260. I then manually add 40 to this
formula, which gives me the correct time of 1300. But this takes a
lot of time.
5. Is there a formula I can use to do this automatically? Or, is
there a way to do my planning with actual times rather than just
numbers that represent miliary times so that if I added 30 minutes to
12:30 I would get 1:00?

- Select cells A1:A3.
- From the "Format" menu, "Cells..." item, get the "Time" option in the
numbers pane, and pick the "1:30 pm" line in the list. Click "OK" button.
- In cell A1, type "12:30" (without the quotes)
- In cell A2, type "0:30"
- In cell A3, type "=A1+A2"

It should display "1:30 pm" now... If it doesn't, indicate what you did and
from which point things don't give the expected result.