Niko on 07 Jan, 2014 12:24 AM
To get the correct total time in Excel please do the following:
- select the Sum field
- go to "Format"-> "Cells..."
- Choose "Category: custom"
- enter [h]:mm into the "Type:" field and click OK
This will calculate the correct sum of all times. (In your example 34:01.)
In the next update the CSV export function will be enhanced. You will be able to choose which fields to include in the table and also optionally add a sum of all time. The update should be available soon!
In the UI you will find the total time of the selected tasks and date range when selecting the "Pie Chart" view.
Please note: The total time displayed in the "Pie Chart" view might not match the total time calculated from the CSV file. That's because within the app he total time is calculated adding up the exact times (down to the millisecond), while in the spreadsheet (generated from the CSV file) only hours and minutes of each timing are added up.