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.

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.

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.