| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN | Excel Worksheet Functions | |||
| Time format to number while keeping value | Excel Worksheet Functions | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
Linear Mode
