Re: Using a formula to add time

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bernard Rey (b.rey_at_DontSpamMe.mvps.org)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 19:55:01 +0200

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.

---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade. 

-- 
Bernard Rey - Toulouse / France
MVP - office:macintosh
Quantcast