There is a new feature in Merlin 2.7.6 and its CSV reading & writting possibilities.
You can now define the unit for the durations and choose one of the following: Seconds, Minutes, Hours, Days, Weeks, Calendarweeks, Months and Years.
This is very practical in case you want to import project information in spreadsheets of MS Excel, Numbers, etc and need further calculations referencing duration data.
In this case simply choose the appropriate unit when exporting. Merlin will recalculate project durations if necessary in the output.
You can also select unit durations in the import dialogue:
- The option in the import dialogue will not enable calculations on duration fields. Merlin will simply accept all numbers as amount of duration in the selected unit. In case you have selected a mismatching duration unit, simply re-open the CSV file and select the correct unit.
- If the given durations already contain a unit in the CSV file, Merlin will preserve it.
Pingback: Merlin import of EXCEL files » MacPM