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....

Adding a Number value to Time
 

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....

Adding a Number value to Time
 

Hi!

Try this:

=B1+SUM(A1:A3)/24

Format the cell as [h]:mm.

Biff

"Corey" wrote in message
...
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....

Adding a Number value to Time
 

Thanks guy,s did it a treat.

Cheers

Corey....


"Max" wrote in message
...
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....

Adding a Number value to Time
 

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