| 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.... |
| 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) | |||
Threaded Mode
