Exporting MS Project Values into Excel

[Paul Peterson - Velox Consulting, LLC]

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.

 

[Mike]

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]

Thanks for your help Mike.

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