Xero Projects when exporting timesheet data. Although there is an option to export time entries in decimal format, the export still outputs
When exporting time entry data from Xero Projects, there is an option to export time entries in decimal format. However, the export still outputs time in hours and minutes (hh:mm) rather than in decimal hours. This makes it difficult to perform calculations in Excel, as SUM formulas do not work correctly with the exported data. And the SUM functions that appear in the Excel and Google Sheets exports do not work.
I would expect that selecting the decimal export option would provide time entries in decimal format (e.g., 1.5 hours instead of 1:30), but this is not happening. It should convert values during the export (and not require ANY additional manual steps after the export).
Christopher Allan
shared this idea
Hi Christopher, appreciate you posting in Xero Product Ideas. I see you've also raised this with our Xero Support team who confirmed this has been raised with our product team. Being more something not working as it should, Our Xero Support team will be best to keep you informed of any updates surrounding this.
