Merlin: CSV duration units

Duration unitsThere 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.

Export options

You can also select unit durations in the import dialogue:

CSV import optionsNote:

  1. 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.
  2. If the given durations already contain a unit in the CSV file, Merlin will preserve it.

One thought on “Merlin: CSV duration units

  1. Pingback: Merlin import of EXCEL files » MacPM

Comments are closed.