In order to correctly import the information to Act! individual fields have to be in a certain format.

 

The duration of an activity should be in the following format:

 

(1) h:mm:ss - general short format, for example, "2:15:00" or "1:45:00"

(2) m - a positive whole number of minutes, for example, "30" or "120"

(3) m min - a positive whole number of minutes which ends with " min", for example, "30 min" or "120 min"

(4) d days - a positive whole number of days which ends with " days", for example, "3 days" or "15 days"

 

The color of an activity should be in the following format:

 

"Color [A=255, R=0, G=255, B=128]". Here, A stands for the transparency of the color (the lower the value the more transparent the color), R for red, G for green and B for blue (the lower the value the less red, green or blue is in the color in the end).  The values for A, R, G and B are between 0 and 255.

 

The duration of an activity is calculated automatically and entered whenever you import the start and end date.

 

A date should be in the following format:

 

dd.MM.yyyy HH:mm (that means two digits for the day, two digits for the month, four digits for the year, separated by a period; as well as - after a blank space - two digits for the hours and two digits for the minutes, separated by a colon)