Time logged (h) field in Excel export should respect pretty/decimal setting

Description

When exporting a timesheet to excel, there is a field for "time logged(h)" which reports the amount of time that was logged in hours. However, when the value is not a whole number, the value is always reported as a decimal, regardless of whether the timesheet in the web UI is set to display time format as decimal or pretty.

I am using this field to import the timesheets into my invoicing system, but unfortunately the invoicing system does not support decimal formatted time intervals, it expects the pretty formatting. i.e. it only works if the value in the spreadsheet says "1:30", not if it says "1.5". My work around for this at the moment is to only log time in whole hours, but obviously this is not ideal. If the excel export could be made to output the time logged(h) field in the format which the timesheet is currently displaying that would solve my problem. Alternatively, if there was some plugin configuration item to set the time output format for exporting, that would also do the job.

Environment

JIRA server 7.7.0 on Amazon Linux w/ nginx HTTPS proxy

Priority

Minor

Assignee

Deniz Oğuz

Reporter

Corch X

Affects versions

Fix versions

Labels

None

Source

None

Jira Version

None

Database Type/Version

None

Browser Type/Version

None
Configure