Problem in CVS export.
The export of "hh.mm" values is wrong if mm<>0.
Please read the comment and let us know more information.
We will discuss if that could be better to switch to time format.
Hi, working on this problem, i have found a workaround.
I have changed, in excel, the way to recognize numbers from CVS import, from "," to "."
So the problem is the localization. Probably, using the time format hh:mm it will work everywhere.
Hi, here some example:
2:30 2.05.00 or 0,086805556 in general format
4:03 4.05.00 or 0,170138889
I use excell 2010.Language: Italian
I need to have exact value of minutes to make correct calculation, but i can manage different format.
Can you give us more information here? What value did you have in the report and what value did you get in CSV?
Currenlty all the minutes are coverted to decimal values so the exported time is a correct number and you can quickly do a math calculation in
Excel, etc. Obviously there is some rounding happening.
Would you prefer the exported document to contain exact minute values?