Agenda Time Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 o
presentation
(in minutes) then in A2 put

=A1 + TIME(0,B1,0)

and copy down as needed. Note this will only work properly when th
length
is in minutes
 
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
 
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!
=====================================================


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top