I am certain there is a really simple way of doing this and I am just too
stupid to figure it out...

I just want to have Row 1 Column B show a start time I manually enter (say
9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to show a
value of 9:25PM in row 2 column B.

Row 2 Column B has time value (9:20PM)
Row 2 Column A has minutes allowed (20)

In other words, add B2 and A3 and show them as a new time in B3.

Any takers???

Hi, if you type just 10 on a2 the formula should be

=b1+time(0;a2;0)

if you type 00:00
is just b1+a2

hth
regards from Brazil
Marcelo

"markndawoods" escreveu:

I am certain there is a really simple way of doing this and I am just too
stupid to figure it out...

I just want to have Row 1 Column B show a start time I manually enter (say
9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to show a
value of 9:25PM in row 2 column B.

Row 2 Column B has time value (9:20PM)
Row 2 Column A has minutes allowed (20)

In other words, add B2 and A3 and show them as a new time in B3.

Any takers???

Or in maths terms without the
time() function

= b1 + (a2/60/24)

Steve

On Mon, 03 Jul 2006 21:36:02 +0100, Marcelo
wrote:

Hi, if you type just 10 on a2 the formula should be

=b1+time(0;a2;0)

if you type 00:00
is just b1+a2

hth
regards from Brazil
Marcelo

"markndawoods" escreveu:

I am certain there is a really simple way of doing this and I am just
too
stupid to figure it out...

I just want to have Row 1 Column B show a start time I manually enter
(say
9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to
show a
value of 9:25PM in row 2 column B.

Row 2 Column B has time value (9:20PM)
Row 2 Column A has minutes allowed (20)

In other words, add B2 and A3 and show them as a new time in B3.

Any takers???

--
Steve (3)

Hi Marcelo,
To help you tie in how the formulas that were supplied as answers
work, you should be aware that time is a fraction of a day. So 6
hours is .25 days, and 20 minutes is =20/(24*60) of a day.

Dates are measured as days past a reference date. You can
read more about Date and Time and their calculations in
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm