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