| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting MS Project Values into Excel
I am exporting the "Actual Work" values from MS Project into an excel
worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes it impossible to use for calculations. I would like some automatic way of making sure this value is always 40 (rather than 40h) - I don't want to manually manipulate my excel file. Any ideas? Thanks. Paul C. Peterson. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exporting MS Project Values into Excel
You could use a macro to do this
Sub hoursWorked() 'Macro to remove h Const hoursColumn = "D" 'Change to your needs Dim iRow As Long iRow = 2 Do While Len(Range(hoursColumn & iRow).Formula) 0 Range(hoursColumn & iRow).Value = Replace(Range(hoursColumn & iRow).Value, "h", "") iRow = iRow + 1 Loop End Sub "Paul Peterson - Velox Consulting, LLC" wrote: I am exporting the "Actual Work" values from MS Project into an excel worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes it impossible to use for calculations. I would like some automatic way of making sure this value is always 40 (rather than 40h) - I don't want to manually manipulate my excel file. Any ideas? Thanks. Paul C. Peterson. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exporting MS Project Values into Excel
Thanks for your help Mike.
"Mike" wrote: You could use a macro to do this Sub hoursWorked() 'Macro to remove h Const hoursColumn = "D" 'Change to your needs Dim iRow As Long iRow = 2 Do While Len(Range(hoursColumn & iRow).Formula) 0 Range(hoursColumn & iRow).Value = Replace(Range(hoursColumn & iRow).Value, "h", "") iRow = iRow + 1 Loop End Sub "Paul Peterson - Velox Consulting, LLC" wrote: I am exporting the "Actual Work" values from MS Project into an excel worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes it impossible to use for calculations. I would like some automatic way of making sure this value is always 40 (rather than 40h) - I don't want to manually manipulate my excel file. Any ideas? Thanks. Paul C. Peterson. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Project values? | Excel Worksheet Functions | |||
| Exporting calculated values | Setting up and Configuration of Excel | |||
| How can I project the values of intersection of curves in chart on | Excel Worksheet Functions | |||
| How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
| project values based on other values | Excel Discussion (Misc queries) | |||
Linear Mode
