CSV Export - Include actual time spent.

Hi, Our team has made improvements to the project CSV export, and it includes the following:

• Time Log: shows the actual time spent on tasks.
• Variation: calculates the difference between the Time Log and the Estimate.
• Duration: represents the remaining time from the Due date to the Start date.

Please try and let me know if you have any issues. Thank you.

Hi, Your feedback has been passed to our team for further discussion. While we can't promise a quick implementation, our team is definitely looking into it. Thank you for your suggestion!

@Raisag Thanks for addressing this so quickly. I've tested it but I can't get it to work like you've displayed in the screenshot.

I've tried changing the format to hh:mm:ss but it doesn't seem to work when there's a negative number. Also, the current calculation is Time Log - Estimate, shouldn't it be Estimate - Timelog? I've attached a screenshot of what I see in the export.

Thanks

@MarcO_Neill I'm Peggy from the Quire team.

About the calculation turning out to be a negative number, this might be a limitation of Excel.

Please try the below settings to change the results.

1. Change the cell format to [h]:mm:ss;-[h]:mm:ss Right-click > Format Cells > Custom > and enter the format [h]:mm:ss;-[h]:mm:ss
2. Then go to the Advanced settings and change the calculation to use 1904 date system Select File > Options > Advanced in the navigation panel > In the 'When calculating this workbook', select 'Use 1904 date system'

From this:

To this:

Please give this a try and let us know if it works!