Stupid question -- time calculation

[Markndawoods]

<sigh>

I know there is an easy way to do this, I am just too stupid to figure it
out...

In cell B1 I enter the start time for a meeting (8:20PM)
In cell A2 I enter the length of time, in minutes the meeting part is given
(10 minutes)
In cell B2 I want to see 8:30PM


Given every meeting starts at 8:20, what is the formula to enter in B2 that
will add A2 and B1???


Go ahead and blast me, I know I must be overlooking something!

Mark

[Marcelo]

look the answer on your other post

"Markndawoods" escreveu:

> <sigh>
>
> I know there is an easy way to do this, I am just too stupid to figure it
> out...
>
> In cell B1 I enter the start time for a meeting (8:20PM)
> In cell A2 I enter the length of time, in minutes the meeting part is given
> (10 minutes)
> In cell B2 I want to see 8:30PM
>
>
> Given every meeting starts at 8:20, what is the formula to enter in B2 that
> will add A2 and B1???
>
>
> Go ahead and blast me, I know I must be overlooking something!
>
> Mark
>
>
>

[mrice]

=b1+timevalue("0:"& A2 &":0")

[Markndawoods]

It's not showing up...

Can you paste into reply here?


> look the answer on your other post
>
> "Markndawoods" escreveu:
>
>> <sigh>
>>
>> I know there is an easy way to do this, I am just too stupid to figure it
>> out...
>>
>> In cell B1 I enter the start time for a meeting (8:20PM)
>> In cell A2 I enter the length of time, in minutes the meeting part is
>> given
>> (10 minutes)
>> In cell B2 I want to see 8:30PM
>>
>>
>> Given every meeting starts at 8:20, what is the formula to enter in B2
>> that
>> will add A2 and B1???
>>
>>
>> Go ahead and blast me, I know I must be overlooking something!
>>
>> Mark
>>
>>
>>

[Marcelo]

=b1+time(0,a2,0)

hth
regareds from Brazil
Marcelo

"Markndawoods" escreveu:

> It's not showing up...
>
> Can you paste into reply here?
>
>
> > look the answer on your other post
> >
> > "Markndawoods" escreveu:
> >
> >> <sigh>
> >>
> >> I know there is an easy way to do this, I am just too stupid to figure it
> >> out...
> >>
> >> In cell B1 I enter the start time for a meeting (8:20PM)
> >> In cell A2 I enter the length of time, in minutes the meeting part is
> >> given
> >> (10 minutes)
> >> In cell B2 I want to see 8:30PM
> >>
> >>
> >> Given every meeting starts at 8:20, what is the formula to enter in B2
> >> that
> >> will add A2 and B1???
> >>
> >>
> >> Go ahead and blast me, I know I must be overlooking something!
> >>
> >> Mark
> >>
> >>
> >>
>
>
>