How calculate total time for a period?

brsnyder117's Avatar

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

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

    Niko's Avatar

    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

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • sum_problem.xlsx 34.6 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

27 Jan, 2023 11:56 AM
27 Jan, 2023 10:25 AM
23 Jan, 2023 04:48 PM
07 Jan, 2023 03:19 AM
16 Dec, 2022 11:29 AM