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 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.
Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂
