PRD said:
When I try exporting data from project to excel using predefined map, the map
does not allow me to change the format of the field. This causese the
duration field to go to excel as "10 hrs" as opposed to "10" whereas I want
later. Any way to fix this ?
PRD,
There are various ways to "fix" this. Here is one way to do it in Excel.
1. Insert a blank column to the right of the imported duration field
2. Select all the values in the duration field but don't select the
header if you elected to include the header in the import
3. Go to Data/Text to Columns
4. Select "delimited" as the original data type if it is not the
default, then hit "next"
5. Select "tab" and "space" as the delimiters, then hit "next"
6. Finally hit "finish"
The numerical value will now be separated from the dimension. Delete the
dimension column and you are all set to format the duration value as
desired.
Another option is to use VBA to export the data from Project to Excel.
If VBA is used, the dimension does not come over, although time values
in Project are stored as minutes so a conversion factor may be necessary.
Hope this helps.
John
Project MVP
