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