I'm trying to create a meeting agenda in excel
In column 1 I have 8:30Am and in column 2 I would like to add :30 (the
length of the presentation)

In the next row I'd like it to add that 30 minutes and start at 9:00am and
then each time the length of a presentation is added it updates the start
time for the next agenda item.

How the heck do I do that? I feel like I've tried everything and can't get
it!

Thanks

If column A has the start time and column B has the length of
presentation
(in minutes) then in A2 put

=A1 + TIME(0,B1,0)

and copy down as needed. Note this will only work properly when the
length
is in minutes.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508916

Format both columns as time and enter 0:30 in B1, not :30. Typing :30
produces a #value error in A2 when adding B1 to A1.

Hans

Its not working. A2 keeps saying 8:30 even though A1 is 8:30 and B1 I typed
in 0:30. What's way to format B?

When I click it on it says 12:30Am even though I typed in 0:30


"flummi" wrote:

Format both columns as time and enter 0:30 in B1, not :30. Typing :30
produces a #value error in A2 when adding B1 to A1.

Hans

Custom format Column A to:
h:mm AM/PM

And Column B to:
h:mm

Then, in A2 enter:
=A1+B1
And copy down as needed.

Now, enter your time in A1 as a *true* XL recognized time, using the colon,
i.e.
8:30

In Column B, enter your length as *true* times, using colons *and* leqading
zeroes where necessary,
i.e.
0:45

Don't worry about the display in the formula bar when you do this.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"accessnewbie" wrote in message
...
Its not working. A2 keeps saying 8:30 even though A1 is 8:30 and B1 I typed
in 0:30. What's way to format B?

When I click it on it says 12:30Am even though I typed in 0:30


"flummi" wrote:

Format both columns as time and enter 0:30 in B1, not :30. Typing :30
produces a #value error in A2 when adding B1 to A1.

Hans

Format columns A and B as time.
When you format a range as time:

hilite the range (e.g. an entire column)
from the main menu select format--cells
on the next window select the "general" tab and click"time"
in the box to the right you will see the various time formats
click the one you want e.g. 13:30 (it seems that you selected 1:30 PM)

then type in A1 08:30
type in B1 0:30

if you have increments in every B cell, type in A2:

=A1+B1

If the increment (0:30) is the same for all cells in the A column, type
in A2:

=A1+$B$1

Copy A2 down as required.

That should display 9:00 in A2, 9:30.in A3 etc

Hans