software

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: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=508916Format 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.

HansIts 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:30quot;flummiquot; wrote:

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

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!
================================================== ===quot;accessnewbiequot; gt; 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:30quot;flummiquot; wrote:

gt; Format both columns as time and enter 0:30 in B1, not :30. Typing :30
gt; produces a #value error in A2 when adding B1 to A1.
gt;
gt; Hans
gt;
gt;
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--gt;cells
on the next window select the quot;generalquot; tab and clickquot;timequot;
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