Adding a Number value to Time

I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc)
Representing Hours

In say Column B i have the time (hh:mm)


EG.


A B
1 0. 0 07:00AM
2 0.5 07:30AM
3 0.75 08:15AM

I want to rather than manually adding say 0.5hour from A2 to B1 time giving
me 07:30AM, i want use a formula to add the hours from column A to Column B


How though?


Corey....

Try in B2: =(A2/24)+B1
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Corey" wrote:
> I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc)
> Representing Hours
>
> In say Column B i have the time (hh:mm)
>
>
> EG.
>
>
> A B
> 1 0. 0 07:00AM
> 2 0.5 07:30AM
> 3 0.75 08:15AM
>
> I want to rather than manually adding say 0.5hour from A2 to B1 time giving
> me 07:30AM, i want use a formula to add the hours from column A to Column B
>
>
> How though?
>
>
> Corey....
>
>
>

Hi!

Try this:

=B1+SUM(A1:A3)/24

Format the cell as [h]:mm.

Biff

"Corey" <[email protected]> wrote in message
news:%23oRyy%[email protected]...
>I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc)
>Representing Hours
>
> In say Column B i have the time (hh:mm)
>
>
> EG.
>
>
> A B
> 1 0. 0 07:00AM
> 2 0.5 07:30AM
> 3 0.75 08:15AM
>
> I want to rather than manually adding say 0.5hour from A2 to B1 time
> giving me 07:30AM, i want use a formula to add the hours from column A to
> Column B
>
>
> How though?
>
>
> Corey....
>

Thanks guy,s did it a treat.

Cheers

Corey....


"Max" <[email protected]> wrote in message
news:[email protected]...
> Try in B2: =(A2/24)+B1
> Copy down
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Corey" wrote:
>> I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc)
>> Representing Hours
>>
>> In say Column B i have the time (hh:mm)
>>
>>
>> EG.
>>
>>
>> A B
>> 1 0. 0 07:00AM
>> 2 0.5 07:30AM
>> 3 0.75 08:15AM
>>
>> I want to rather than manually adding say 0.5hour from A2 to B1 time
>> giving
>> me 07:30AM, i want use a formula to add the hours from column A to Column
>> B
>>
>>
>> How though?
>>
>>
>> Corey....
>>
>>
>>

You're welcome, Corey
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Corey" wrote:
> Thanks guys, did it a treat.