Thanks for catching the error, Dave. I was fixated on the wrong parameters for
the Time function, I forgot to verify whether b1 was time or hours.

--
Regards,
Fred


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Are you sure, Fred? That would work if B1 was 8:30, but I believe that the OP
meant that he had 8.5 in B1.
In that case, he needs
=A1+B1/24+time(0,30,0)
--
David Biddulph

"Fred Smith" wrote in message
...
You want:

c1: =a1+b1+time(0,30,0)

--
Regards,
Fred


"alex" wrote in message
...
Hello experts,

Question on how to add hours to a time...

E.g., I have a time in A1 (let's say 6:06 AM)
I want to add an amount to A1 (let's say 8.5 hrs in cell B1)
My formula in C1 = A1+ Time(B1,30,0) [i'm adding a half hour for
lunch]

My formula returns 2:36 PM, I want it to return 3:06 PM (6:06 AM plus
8.5 hrs plus 30 minutes).

This formula works well when the amount in B1 is an integer (I know
this is obvious because the Time function reads Time(hour, minute,
second).

I need a way to calculate a partial hour. I'd like this formula to
remain dynamic; i.e., allowing me to dump my start time in one cell,
my hours (any hour(s)) in another cell, and my ending hours in the
final cell. Keep in mind the time in A1 will change daily, as well as
the hours in cell B1; the 30 min for lunch, however, will not.

Thoughts?