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
Thanks for submitting your idea on Xero Product Ideas. We appreciate you taking time to let us know how we could improve Xero for you.
Your feedback will soon be reviewed by our Community team, and in the meantime this can begin to build support with votes from other community members.
If you're interested to see recent releases or get a pulse on what's coming soon see The Long and Short of it. 🙂