Home → Problems with Timelime for Mac →

How calculate total time for a period?

• Edit

brsnyder117

06 Jan, 2014 10:02 PM

When I export to a CSV file, the times are being formatted as time of day, so there's no way to sum them. Excel isn't recognizing them as any kind of number, or even text. Even though the data comes in as General format, :38 is converted to 12:38 AM etc. I've tried converting them to different formats, but the results are meaningless and useless.

If I can't total the time spent, I'm at a loss to determine what the value of the CSV export capability is in the first place.

I also can't find totals anywhere in the UI, which would at least let me manually mark up the Excel file, so I am really puzzled. I have two weeks of timings selected and none of the report types on the right show a total. What am I missing here?

Thanks -- Barbara

• sum_problem.xlsx 34.6 KB

1. Support Staff 1 Posted by Niko on 07 Jan, 2014 12:24 AM

   

   Hi Barbara!

   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.

   I hope this helps!

   Have a great day,
   Niko

   • Edit