different number formats (time spent) in excel view

[Former user]

the "time spent" number format in the Excel view of Timesheet Report seems to be different. So it's impossible to add an calculation based on this field. It may be that the entries with different language settings have been made. But this is not not inevitable.

Installed Plugin Version: 2.5.4

[Andriy Zhdanov]

It must be incorrectly conveted by Excel, when there is 3 decimal digits. Could you please try setting number format for the column in Excel itself? Otherwise you may want to use decimalSeparator option to force coma, see http://www.jiratimesheet.com/#/wiki/Advanced_Configuration/Decimal_separator_for_hours

Please let me know if it helps.

Thank you.

[Former user]

Thanks for the quickly reply. The decimalSeparator option works fine.

regards, david

[Andriy Zhdanov]

Great, thank you for confirmation!